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 “coala” with Change Limit: [1] [2]

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

105 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
coala7752112(None) 
coal66939251coal_
coalas87418961coalas
coals76129601coals
coaly105521591coaly
cola66541391co_la
koala95112211koala
ala312463602__ala
bola66035562bo_la
boyla102912362boyla
cabala103516912cabala
caca85528082c_aca
calf96339562c_alf
calk105527662c_alk
call66838672c_all
calla74827072calla
calm85032362c_alm
calo64936442c_alo
calx135722792c_alx
casa65630862c_asa
cella75420312cella
chalah143511662chalah
chalk144814602chalk
challa114014192challa
chela103916802chela
choana1138442choana
chola104718032chola
cholla113911022cholla
cicala10310062cicala
cloaca1037262cloaca
coach125919452coach
coact96130582coact
coagula1045412coagula
coaled95022712coaled
coaler84121712coaler
coapt96131532coapt
coast75236272coast
coat67558352coa_t
coati75624642coati
coats75635002coats
coax136922982coa_x
coaxal15387302coaxal
cobalt10317392cobalt
cobia94117512cobia
coble94823172coble
cobra95214402cobra
coca88030642co_ca
cocoa98517882cocoa
coda77029352co_da
coil66439652coil_
coils75030082coils
col59360352co_l_
colas75436772colas
cold77338772co_ld
cole66956112co_le
collar83816172collar
colly104926772colly
cols66553082co_ls
colt67158242co_lt
coly96940532co_ly
colza165112982colza
coma87134852co_ma
comal95125132comal_
comma114514792comma
conga85419872conga
cool66940492cool_
cools75632632cools
cooly105525422cooly
copal95621782copal_
copalm125010812copalm
copals105018942copals
copra98115462copra
copula102812052copula
coral76033452coral_
corals85325142corals
coria75828322coria
costa75523732costa
cotta75818572cotta
could86517712could
cowl97530812cowl_
cowls106922212cowls
coxa136922962co_xa
coxal146116672coxal_
coyly135614892coyly
craal74117752craal
dobla84913642dobla
doula65717772doula
foal76630922foal_
foals85721692foals
gala55635162_gala
goal55829302goal_
goals65521292goals
holla84918492holla
koalas104011662koalas
kola85124972ko_la
mola66035632mo_la
moola75117032moola
nala46930392_nala
nyala836822nyala
olla44821172_olla
sola45541862so_la
tala45938052_tala
tola45236332to_la
voila84813942voila
woald94813072woald

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001051.75030742.9
3Display Results1051050.0303500.0
 (SQL Overall)1786911052.09385375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.