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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
chloride14331024(None) 
chlorid133211841chlorid_
chlorides15289751chlorides
chlorids14299671chlorids
chlorine133013301chlorine
chlorite133012841chlorite
calorie92716902calori_e
calorize192712742calorize
chlorate133112692chlorate
chloric143410612chlori_c
chloridic1754602chloridic
chlorin123113002chlori_n
chlorines142512352chlorines
chlorins132612882chlorins
chlorites142311962chlorites
chorine123218362ch_orine
chromide1648052chromide
colorize192314202colorize
boride9415903__boride
caloric113413223calori_c
calorics122810463calorics
calories102919563calories
calorized21249673calorized
calorizes202312303calorizes
charade13129913ch_arade
cheloid13310833chelo_id_
cheloids1438033chelo_ids
chide115321023ch___ide
chloracne1644513chloracne
chloral12169983chlor_al
chlorals13148033chlorals
chloramine1746113chloramine
chlorates142512273chlorates
chlordan1445493chlordan
chlordane1544913chlordane
chlorinate1546123chlorinate
chloritic1657433chloritic
chloroses1447693chloroses
chlorous1339223chlorous
choice132010523ch_o_ice
choired13349343ch_oired
choline122915383ch_oline
chopine143512263ch_opine
chorale124313353ch_orale
chord115917263ch_or_d_
chorded144710553ch_or_ded
chords125214633ch_or_ds
chore105126763ch_or__e
chored125321883ch_ored_
chorial124214143ch_orial
choric133515903ch_ori_c
chorines132917253ch_orines
choring133617663ch_oring
chorion12311773ch_orion
chorizo2136323ch_orizo
choroid13311803ch_oroid_
choroids1438703ch_oroids
chortle124210443ch_ortle
chromides1747603chromides
chromite15310833chromite
chromize2447683chromize
chytrid1645733chytrid_
chytrids1744223chytrids
clerid9312413c_lerid_
clerids1049093c_lerids
collide103214793col_lide
colonise102514283colonise
colonize192312773colonize
colorado1145933colorado
colored10313473colored_
coloreds1138093coloreds
coloring11414843coloring
colorism122112433colorism
colorist102818993colorist
colorized212211773colorized
colorizer202410623colorizer
colorizes203014523colorizes
florid10311453_florid_
fluoride1245873fluoride
gloried9169523_gloried
hagride1237553_hagride
hayride1437323_hayride
horde94623053_h_or_de
hydride15257503_hydride
theorise1137873theorise
theorize2047073theorize
thorite10313443th_orite
valorise112110313valorise
valorize20239623valorize

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 Limit146162896.61022112.3
3Display Results89890.0332697.0
 (SQL Overall)178691897.06325299.6
 
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.