Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “arroyo” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
arroyo93696(None) 
arroyos1036531arroyos
arioso64312402arioso
array86317142array_
arrays95311682arrays
arroba898662arroba
arrow83414882arro_w
arrows92813482arrows
arrowy12288272arrowy
karroo10410012karro_o
abroad9310943abroad
achoo10315083acho_o
acronym1445673acronym
across8312643across
adobo84711593a_dobo
adroit7518793adroit
aero45435343aer__o
aerobe8412403aerobe
aerosol747683aerosol
aerugo735803aerugo
aery77231683aer_y_
ahoy101919183a_hoy_
airy75734153air_y_
alloy85519973alloy_
alloys94014563alloys
ammono1047373ammono
amoroso946093amoroso
annoy869713annoy_
annoys967523annoys
apron7318833apro_n
aprons8316993aprons
apropos1138843apropos
araroba945763araroba
arbor74818113arbo_r
arbors84717883arbors
arbour84211333arbour
arco68331543a_r_co
ardor64617863ardo_r
ardors74416873ardors
ardour74110903ardour
areola6813673areola
areole61017283areole
argol65317263argo_l
argols74514613argols
argon65520593argo_n
argons75018203argons
argosy1036423argosy
argot67728653argo_t
argots74116033argots
ariose64818723ariose
ariosi64313033ariosi
ariosos7409853ariosos
aristo6414033aristo
arkose104911343arkose
armor75118053armo_r
armors85017813armors
armory114211473armory
armour84411853armour
army96624183a_rmy_
arnotto7134733arnotto
aroid65428343a_roid
aroma71220143a_roma
arose55832083a_rose
aroynt9312893a_roynt
arrack121110253arrack
arrant6623253arrant
arras55626133arr_as
arrayal1055843arrayal
arrayed11117153arrayed
arrayer10136703arrayer
arrear6310253arrear
arrest63722633arrest
arriba867683arriba
arris56824683arr_is
arrive91311793arrive
arrobas969213arrobas
arrowed1148113arrowed
arseno6318913arseno
arsino64113513arsino
arson55118833arso_n
arsons63917213arsons
artsy86012963artsy_
arty77531313a_rty_
arvo76023433a_r_vo
arvos86015663arvo_s
aryl75922343a_r_yl
aurora6411763aurora
aurous64119263aurous
awry107619683awr_y_
barrio8312573barr_io
barroom1139373barroom
barrow114512763barro_w
barrows123411683barrows
boyo96923843__boyo
bromo95217203_bromo
broo65129823_bro_o
carboy134914183carboy_
carboys144711783carboys
carroch1437093carroch
carrom10513403carro_m
carroms11512403carroms
carrot8423123carro_t
carrots9714623carrots
carroty1248943carroty
carry105823783carr_y_
carryon1237033carryon
chromo132811013chromo
error53712233erro_r
errors63311313errors
farrago1144923farrago
farrow12309973farro_w
farrows13259783farrows
garron73113493garro_n
garrons82713463garrons
garrote8510103garrote
harrow122610773harro_w
harrows132611033harrows
harry115322953harr_y_
iroko939663_iroko
karoo92519583karo_o
karroos1139313karroos
madrono10288743madrono
marrano939423marrano
marron83717543marro_n
marrons93216973marrons
marrow112812603marro_w
marrows122911823marrows
marrowy15236083marrowy
marry104821693marr_y_
narrow9269143narro_w
narrows10258843narrows
parrot8320663parro_t
parrots9312743parrots
parroty1247863parroty
parry105323753parr_y_
promo95620003_promo
proso77222413_proso
roto45935053__roto
stroy87720393stroy_
stroys95914603stroys
tarry85422513tarr_y_
toyo76925453__toyo
troy77429683_troy_
troys86418613_troys
yarrow12287933yarro_w
yarrows13277853yarrows

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.376475242.0
2DLD Change Limit1127161465.61020092.0
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.03229623.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.