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 “chlorals” 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.

110 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
chlorals1314803(None) 
chloral12169981chloral_
chorals124614111ch_orals
caporals1238922caporals
chloralose1552792chloralose
chlorate133112692chlorate
chlorates142512272chlorates
chlordans1544892chlordans
chlorids14299672chlorids
chlorins132612882chlorins
chlorous1339222chlorous
choral115118492ch_oral_
chorale124313352ch_orale
chorales133712882ch_orales
corals85325142c__orals
florals104210062_florals
balmorals1343253balmorals
bharals1236733bh_arals
borals86721913__borals
calomels1236133calomels
calorics122810463calorics
calories102919563calories
caltraps12327253caltraps
caporal11410943caporal_
centrals102712033centrals
ceorls848163c_eor_ls
chakras16428503chakra_s
charas114223613ch_ara_s
chiral114614413ch_iral_
chloracne1644513chloracne
chloracnes1744443chloracnes
chloralosed1751573chloralosed
chloraloses1652793chloraloses
chlordan1445493chlordan
chlordane1544913chlordane
chlordanes1644513chlordanes
chlorella1493663chlorella
chlorellas15103333chlorellas
chloric143410613chlor_ic
chlorid133211843chlor_id
chloride143310243chloride
chlorides15289753chlorides
chlorin123113003chlor_in
chlorine133013303chlorine
chlorines142512353chlorines
chlorite133012843chlorite
chlorites142311963chlorites
chloroses1447693chloroses
chlorosis1446193chlorosis
cholas114818003ch_ola_s
choleras13289043cholera_s
chollas123811353cholla_s
choragi1346683ch_oragi
choragus1474303ch_oragus
chorally1638103ch_orally
chordal13449883ch_ordal_
chords125214633ch_or_ds
choreal124412223ch_oreal_
choreas124414203ch_oreas
chores114828023ch_or_es
chorial124214143ch_orial_
chortle124210443ch_ortle
chortles133611323ch_ortles
chorus115014773ch_or_us
chromas142512693chroma_s
chromyls18244733chromyls
churls115411073ch_ur_ls
citrals91111673c_itrals
cloaks124411263c_lo_aks
clonal8310913c_lonal_
coals76129603c__o_als
colonels104210463colonels
colonials1147913colonials
colorable1348243colorable
colorably1646153colorably
colorado1145933colorado
colorant10414723colorant
colorants1149863colorants
coloreds1138093coloreds
colorers10312183colorers
colors86622373color__s
colorways1743723colorways
copals105018943c__opals
coral76033453c__oral_
coronals103312913coronals
corporals1347273corporals
corrals93713853c_orrals
dhooras1135943dhoora_s
floral94313813_floral_
floras94715693_flora_s
goorals838713_goorals
gorals76917653__gorals
hoorahs13399613_hoorahs
hoorays13418383_hoorays
horahs126313873_h_orahs
horal86328683_h_oral_
horas86333103_h_ora_s
kilorads1344423kilorads
locals83714503__locals
loral55927823__loral_
lorans65117603__lorans
morals85324643__morals
ochlocrats1752353ochlocrats
orals55826483___orals
plurals936913_plurals
schorls1248353sch_or_ls
shoals94215793sh_o_als
shorans102812413sh_orans
shorls94516203sh_or_ls
whorls124410163wh_or_ls

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621107.20320291.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.66923300.4
 
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.