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

154 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
chlorid13321184(None) 
chloric143410611chloric
chloride143310241chloride
chlorids14299671chlorids
chlorin123113001chlorin
caloric113413222caloric
calorie92716902calorie
cheloid13310832chelo_id
chloral12169982chloral
chlorides15289752chlorides
chloridic1754602chloridic
chlorine133013302chlorine
chlorins132612882chlorins
chlorite133012842chlorite
chord115917262ch_or_d
chored125321882ch_ored
choric133515902ch_oric
choroid13311802ch_oroid
chytrid1645732chytrid
clerid9312412c_lerid
colored10313472colored
florid10311452_florid
calorics122810463calorics
calories102919563calories
calorize192712743calorize
calorized21249673calorized
calory11312843calor_y
carotid102014833carotid
ceboid11310653cebo_id
celosia939463celosia
chadri1238143chadri_
chagrin1337893chagrin
chaired134211243chaired
chalcid1537883chalcid
chaotic14310043chaotic
chard116124743ch_ar_d
chared125423693ch_ared
charred134614483charred
cheered133713293cheered
cheerio12379313cheerio
cheloids1438033chelo_ids
chid106626403ch___id
chilopod1694653chilopod
chirred133612123chirred
chlorals13148033chlorals
chlorate133112693chlorate
chlordan1445493chlordan
chlorines142512353chlorines
chlorites142311963chlorites
chloritic1657433chloritic
chlorosis1446193chlorosis
chlorotic1656983chlorotic
chlorous1339223chlorous
choir105313603ch_o_ir
choired13349343choired
choirs114911883ch_oirs
choked164914793ch_oked
choleric15107913choleric
choleroid1545943choleroid
chopin132712193ch_opin
choral115118493ch_oral
chorded144710553ch_orded
chords125214633ch_ords
chore105126763ch_or_e
chorea115216093ch_orea
choreic1438703ch_oreic
choreoid1447923ch_oreoid
chores114828023ch_ores
chorial124214143ch_orial
chorine123218363ch_orine
choring133617663ch_oring
chorioid1448333ch_orioid
chorion12311773ch_orion
chorizo2136323ch_orizo
choroids1438703ch_oroids
chorus115014773ch_orus
chowed154914653ch_owed
chromed153510923chromed
chromic1639863chromic
chromide1648053chromide
chronic14311423chronic
churred13409173churred
chytrids1744223chytrids
ciboria1147043ciboria
cleric10612133c_leric
clerids1049093c_lerids
clod76124613c_lo__d
cloned94518803c_loned
clonic104914673c_lonic
closed95317973c_losed
cloud86716423c_lo_ud
cloured103111543c_loured
cloyed125111563c_loyed
colloid10312883colloid
colobi105011083colobi_
coloni85619203coloni_
colonic115015713colonic
color76123743color__
colorado1145933colorado
coloreds1138093coloreds
colorer9312523colorer
coloring11414843coloring
colorism122112433colorism
colorist102818993colorist
colorize192314203colorize
colorized212211773colorized
colors86622373color_s
coloured1148313coloured
colubrid1344413colubrid
comorbid1545033comorbid
conoid9818883cono_id
cord76740923c__or_d
cored85044223c__ored
coria75828323c__oria
corvid12310473c__orvid
cuboid1139503cubo_id
culicid1247383culicid
culprit1147863culprit
cycloid1539283cyclo_id
cymoid1459473cymo_id
florin9312653_florin
fluorid1136783fluorid
gloria71910553_gloria
gloried9169523_gloried
haloid104317763halo_id
horrid10311563_horrid
hybrid15237813_hybrid
hydrid14248973_hydrid
hyoid12612443_hyo_id
keloid11812623kelo_id
kilorad1245393kilorad
leporid1048153leporid
loid55531493__lo_id
lord55032083__lor_d
loris55329153__loris
lurid64618973__lurid
meloid9616003melo_id
milord999573milor_d
oceloid1037973ocelo_id
ochroid1357903ochro_id
peloria9310953peloria
peloric11310713peloric
pylori1147163pylori_
pyloric1438063pyloric
remorid10311863remorid
shored105723653sh_ored
silurid837013silurid
sloid64619713_slo_id
theroid11313403theroid
thoria93012893th_oria
thoric114314043th_oric
thyroid1438253thyroid
whored135512123wh_ored
xyloid1738193xylo_id

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271545.97022450.1
3Display Results1541540.0463347.8
 (SQL Overall)1786911546.41927837.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.