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

121 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
chlorids1429967(None) 
chlorid133211841chlorid_
chloride143310241chloride
chlorides15289751chlorides
chlorins132612881chlorins
calorics122810462calorics
calories102919562calories
cheloids1438032chelo_ids
chlorals13148032chlorals
chloric143410612chlori_c
chloridic1754602chloridic
chlorin123113002chlori_n
chlorine133013302chlorine
chlorines142512352chlorines
chlorite133012842chlorite
chlorites142311962chlorites
chlorous1339222chlorous
chords125214632ch_or_ds
choroids1438692ch_oroids
chytrids1744222chytrids
clerids1049092c_lerids
coloreds1138092coloreds
caloric113413223calori_c
calorie92716903calori_e
calorize192712743calorize
calorizes202312303calorizes
carotids11229943carotids
ceboids1237653cebo_ids
celeries10316313celeries
celosias1048903celosias
chagrins1437073chagrins
chalcids1635893chalcids
chards125119733ch_ar_ds
cheerios13317583cheerios
cheloid13310833chelo_id_
cherries131812983cherries
chicories1688763chicories
chilopods1774643chilopods
chloral12169983chlor_al
chlorate133112693chlorate
chlorates142512273chlorates
chlordan1445493chlordan
chlordans1544893chlordans
chloritic1657433chloritic
chloroses1447683chloroses
chlorosis1446193chlorosis
choirs114911883ch_o_irs
chopins142312243ch_opins
chorals124614113ch_orals
chord115917263ch_or_d_
choreas124414203ch_oreas
chored125321883ch_ored_
chores114828023ch_or_es
chorial124214143ch_orial
choric133515903ch_ori_c
chorine123218363ch_orine
chorines132917253ch_orines
choring133617663ch_oring
chorioids1545683ch_orioids
chorion12311773ch_orion
chorions13310663ch_orions
chorizo2136323ch_orizo
chorizos2245493ch_orizos
choroid13311803ch_oroid_
chorus115014773ch_or_us
chromide1648053chromide
chromides1747603chromides
chronics1538683chronics
chytrid1645733chytrid_
claries93422203c_laries
clerics1149333c_lerics
clerid9312413c_lerid_
clods85320863c_lo__ds
clouds94612353c_lo_uds
colloids11310173colloids
colonics123711613colonics
colonies103620013colonies
colorado1145933colorado
colored10313473colored_
colorers10312183colorers
coloring11414843coloring
colorings1247683colorings
colorism122112433colorism
colorisms132810793colorisms
colorist102818993colorist
colorists112313593colorists
colorize192314203colorize
colorizes203014523colorizes
colors86622373color__s
colubrids1443603colubrids
conoids10813883cono_ids
cords86030623c__or_ds
corvids1337683c__orvids
cuboids1236723cubo_ids
culicids1345623culicids
culprits1245583culprits
cycloids1647043cyclo_ids
florid10311453_florid_
florins10311643_florins
fluorids1245493fluorids
glorias81610323_glorias
glories81915923_glories
haloids113012553halo_ids
hybrids16236023_hybrids
hydrids15267233_hydrids
hyoids1377673_hyo_ids
keloids1288663kelo_ids
kilorads1344423kilorads
leporids1145673leporids
loids66220703__lo_ids
lords64923503__lor_ds
lories64933043__lories
loris55329153__lori_s
meloids10911453melo_ids
milords10117853milor_ds
pelorias10410593pelorias
silurids945103silurids
sloids73712693_slo_ids
theories11311593theories
thorias102312053th_orias
thyroids1546003thyroids

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.423422437.4
2DLD Change Limit1461621216.67321903.5
3Display Results1211210.0602016.7
 (SQL Overall)1786911217.15624970.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.