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
chlorals1314802(None) 
chloral12169981chloral_
chorals124614101ch_orals
caporals1238922caporals
chloralose1552782chloralose
chlorate133112692chlorate
chlorates142512262chlorates
chlordans1544892chlordans
chlorids14299662chlorids
chlorins132612882chlorins
chlorous1339212chlorous
choral115118492ch_oral_
chorale124313352ch_orale
chorales133712872ch_orales
corals85325142c__orals
florals104210062_florals
balmorals1343253balmorals
bharals1236733bh_arals
borals86721913__borals
calomels1236133calomels
calorics122810463calorics
calories102919543calories
caltraps12327253caltraps
caporal11410943caporal_
centrals102712033centrals
ceorls848163c_eor_ls
chakras16428483chakra_s
charas114223593ch_ara_s
chiral114614413ch_iral_
chloracne1644513chloracne
chloracnes1744443chloracnes
chloralosed1751563chloralosed
chloraloses1652783chloraloses
chlordan1445493chlordan
chlordane1544913chlordane
chlordanes1644513chlordanes
chlorella1493663chlorella
chlorellas15103333chlorellas
chloric143410603chlor_ic
chlorid133211833chlor_id
chloride143310243chloride
chlorides15289743chlorides
chlorin123112993chlor_in
chlorine133013303chlorine
chlorines142512353chlorines
chlorite133012843chlorite
chlorites142311963chlorites
chloroses1447673chloroses
chlorosis1446173chlorosis
cholas114817993ch_ola_s
choleras13289023cholera_s
chollas123811353cholla_s
choragi1346683ch_oragi
choragus1474293ch_oragus
chorally1638103ch_orally
chordal13449883ch_ordal_
chords125214633ch_or_ds
choreal124412223ch_oreal_
choreas124414203ch_oreas
chores114828023ch_or_es
chorial124214143ch_orial_
chortle124210443ch_ortle
chortles133611323ch_ortles
chorus115014763ch_or_us
chromas142512683chroma_s
chromyls18244733chromyls
churls115411073ch_ur_ls
citrals91111663c_itrals
cloaks124411263c_lo_aks
clonal8310913c_lonal_
coals76129603c__o_als
colonels104210453colonels
colonials1147903colonials
colorable1348243colorable
colorably1646153colorably
colorado1145933colorado
colorant10414723colorant
colorants1149863colorants
coloreds1138093coloreds
colorers10312183colorers
colors86622373color__s
colorways1743723colorways
copals105018943c__opals
coral76033453c__oral_
coronals103312893coronals
corporals1347273corporals
corrals93713853c_orrals
dhooras1135943dhoora_s
floral94313813_floral_
floras94715693_flora_s
goorals838703_goorals
gorals76917653__gorals
hoorahs13399603_hoorahs
hoorays13418373_hoorays
horahs126313873_h_orahs
horal86328673_h_oral_
horas86333093_h_ora_s
kilorads1344423kilorads
locals83714503__locals
loral55927823__loral_
lorans65117603__lorans
morals85324633__morals
ochlocrats1752353ochlocrats
orals55826483___orals
plurals936913_plurals
schorls1248353sch_or_ls
shoals94215783sh_o_als
shorans102812403sh_orans
shorls94516193sh_or_ls
whorls124410163wh_or_ls

Search took 9 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.1701051123.5
2DLD Change Limit1461621108.05018156.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.26621617.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.