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

88 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
chlorides1528975(None) 
chloride143310241chloride_
chlorids14299671chlorid_s
chlorines142512351chlorines
chlorites142311961chlorites
calories102919562calori_es
calorizes202312302calorizes
chlorates142512272chlorates
chlorid133211842chlorid__
chloridic1754602chloridic
chlorine133013302chlorine_
chlorins132612882chlori_ns
chlorite133012842chlorite_
chloroses1447692chloroses
chorines132917252ch_orines
chromides1747602chromides
colorizes203014522colorizes
borides10515153__borides
calorics122810463calori_cs
calorie92716903calori_e_
calorize192712743calorize_
calorized21249673calorized
celeries10316313celeri_es
charades141310853ch_arades
cheloids1438033chelo_id_s
cherries131812993cherri_es
chicories1688773chicori_es
chides124620473ch___ides
chlamydes2062293chlamydes
chloracnes1744443chloracnes
chlorals13148033chlor_als
chloramines1845523chloramines
chlorate133112693chlorate_
chlordan1445493chlor_dan
chlordanes1644513chlordanes
chlordans1544893chlordans
chloric143410613chlori__c
chlorin123113003chlori__n
chlorinates1645543chlorinates
chloritic1657433chloritic
chlorosis1446193chlorosis
chlorous1339223chlor_ous
choices142010613ch_o_ices
cholines132214493ch_olines
chopines152711733ch_opines
chorales133712883ch_orales
chorded144710553ch_or_ded
chords125214633ch_or_d_s
chores114828023ch_or__es
chorine123218363ch_orine_
chorions13310663ch_orions
chorizos2245493ch_orizos
choroids1438703ch_oroid_s
chortles133611323ch_ortles
choruses1339983ch_oruses
chromide1648053chromide_
chromites16310963chromites
chromizes2547603chromizes
chytrids1744223chytrid_s
claries93422203c_lari_es
clerids1049093c_lerid_s
clitorides1344453clitorides
collides113214473col_lides
colonies103620013coloni_es
colonises112814013colonises
colonizes202613183colonizes
coloreds1138093colored_s
colorings1247693colorings
colorisms132810793colorisms
colorists112313593colorists
colorize192314203colorize_
colorized212211773colorized
colorizer202410623colorizer
colorizers21267603colorizers
fluorides1345823fluorides
glories81915923_glori_es
hagrides1337623_hagrides
hayrides1536883_hayrides
hordes104921633_h_or_des
hydrides16276943_hydrides
lories64933043__lori_es
lorises73918593__lorises
theories11311593theori_es
theorises1247813theorises
theorizes2147073theorizes
thorites11312393th_orites
valorises122210193valorises
valorizes21249083valorizes

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 Filter1786911486410.423422437.4
2DLD Change Limit148641887.43619989.4
3Display Results88880.0461913.0
 (SQL Overall)178691887.90522604.8
 
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.