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

117 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
chromates1631311(None) 
chromate15312781chromate_
chromites16310961chromites
achromats1647622achromat_s
bichromates2054692bichromates
bromates12413142_bromates
chlorates142512272chlorates
cholates132414762ch_olates
chordates1547682chordates
chromas142512692chroma__s
chromatic18412342chromatic
chromatics1948682chromatics
chromatid17410912chromatid
chromatids1847172chromatids
chromatin16410752chromatin
chromatins1749122chromatins
chromes142914932chrom__es
chromides1747602chromides
chromite15310832chromite_
chromizes2547602chromizes
comates114123642c__omates
coronates1110816922coronates
corotates112714282corotates
cremates124216002c_remates
dichromates1956072dichromates
abrogates12108973abrogates
achromat15410103achromat__
achromatic1949023achromatic
achromatism2055323achromatism
achromatizes2854693achromatizes
arrogates10129423arrogates
automates11412053automates
bichromate1954613bichromate_
bichromated2153503bichromated
bromate11313553_bromate_
bromated1339173_bromated
carates95630613car__ates
carbamates1645623carbamates
carbonates1449133carbonates
casemates1349523casemates
cellmates1347513cellmates
cerates95428253cer__ates
chamades16138653ch_amades
checkmates2343383checkmates
chelates132713843ch_elates
chlorate133112693chlorate_
chlorites142311963chlorites
chocolates1746783chocolates
cholate122114933ch_olate_
chorales133712883ch_orales
chordate1448033chordate_
chroma132912473chroma___
chrome133214813chrom__e_
chromed153510923chrom__ed
chromide1648053chromide_
chromier1538033chrom_ier
chromiest1637783chrom_iest
chromings17286093chromings
chromiums1844543chromiums
chromize2447683chromize_
chromized2645913chromized
chromogen1744893chromogen
chromogens1844643chromogens
chromos142610273chrom__os
chromous15258343chrom_ous
chromyls18244733chrom_yls
chronaxies2244383chronaxies
climates12311973c_limates
cocomats1449403cocomat_s
coelomates1497573coelomates
cohobates1646523cohobates
coinmates1348343coinmates
colocates13312853colocates
comakes154413643c__omakes
comate104124843c__omate_
comtes106222813c__om_tes
copemates1549483copemates
corelates11314863corelates
coronate103018213coronate_
coronated123313323coronated
corotate102813933corotate_
corotated122810053corotated
corporates14410733corporates
crates85736063c_r__ates
creates95225203c_r_eates
cremate113816183c_remate_
cremated133412963c_remated
crewmates16375803crewmates
croutes94815653c_ro_utes
curates95323833cur__ates
derogates11310973derogates
dichromate1856033dichromate_
dichromats1855073dichromat_s
formates132814293for_mates
fromages1437073_fromages
hamates122917683_h_amates
homages131011583_h_omages
humates122813193_h_umates
ostomates1149343ostomates
perorates11417023perorates
phonates13410643ph_onates
phorates13413043ph_orates
primates121515933_primates
probates12414283_probates
promotes12314123_promotes
pronates10418373_pronates
prorates10418073_prorates
remates93827113__remates
rotates72819773__rotates
schoolmates1853643schoolmates
shipmates1645953shipmates
sororates9410473sororates
stomates10313343_stomates
thionates12106663thionates
throated1247923thro_ated
throats104612193thro_at_s
workmates1845003workmates

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.420425454.8
2DLD Change Limit1486411177.23320550.4
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.71623158.5
 
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.