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

137 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
chromate1531278(None) 
chromates16313111chromates
chromite15310831chromite
achromat15410102achromat_
achromats1647622achromats
bichromate1954612bichromate
bromate11313552_bromate
chlorate133112692chlorate
cholate122114932ch_olate
chordate1448032chordate
chroma132912472chroma__
chromas142512692chroma_s
chromatic18412342chromatic
chromatid17410912chromatid
chromatin16410752chromatin
chrome133214812chrom__e
chromide1648052chromide
chromites16310962chromites
chromize2447682chromize
comate104124842c__omate
coronate103018212coronate
corotate102813932corotate
cremate113816182c_remate
dichromate1856032dichromate
abrogate11129603abrogate
achromatic1949023achromatic
achromatize2755433achromatize
arrogate91210323arrogate
automate10411943automate
bichromated2153503bichromated
bichromates2054693bichromates
bromated1339173_bromated
bromates12413143_bromates
carate84734003car__ate
carbamate1546023carbamate
carbonate13410513carbonate
carinate103320253carinate
casemate1239843casemate
cellmate1237873cellmate
celomata1296633celomata
cerate84829463cer__ate
chamade15138453ch_amade
checkmate2243533checkmate
chelate122914903ch_elate
chlorates142512273chlorates
chlorite133012843chlorite
chocolate1647413chocolate
cholates132414763ch_olates
chorale124313353ch_orale
chordates1547683chordates
chromatics1948683chromatics
chromatids1847173chromatids
chromatins1749123chromatins
chromed153510923chrom_ed
chromes142914933chrom_es
chromic1639863chrom_ic
chromides1747603chromides
chromier1538033chromier
chroming163410723chroming
chromium1745983chromium
chromized2645913chromized
chromizes2547603chromizes
chromo132811013chrom__o
chromogen1744893chromogen
chromos142610273chrom_os
chromous15258343chromous
chromy16309903chrom__y
chromyl17275233chrom_yl
chromyls18244733chromyls
chronaxie2153813chronaxie
chronaxy2343253chronaxy
cirrate92413493cir_rate
climate11312833c_limate
cocomat13413623cocomat_
cocomats1449403cocomats
coelomate1398113coelomate
cohobate1547013cohobate
coinmate1239063coinmate
colocate12313443colocate
comade114415323c__omade
comae97128423c__oma_e
comake144413423c__omake
comates114123643c__omates
comte96125473c__om_te
copemate1439993copemate
cordate10315223cor_date
corelate10516013corelate
corollate1148123corollate
coronae94214893corona_e
coronated123313323coronated
coronates1110816923coronates
corotated122810053corotated
corotates112714283corotates
corporate13410903corporate
crate76537403c_r__ate
create85126383c_r_eate
cremated133412963c_remated
cremates124216003c_remates
crenate93317113c_renate
crewmate15405633crewmate
croute84617273c_ro_ute
curate85226243cur__ate
curtate9312643cur_tate
derogate10311353derogate
dichromat1756453dichromat_
dichromates1956073dichromates
dichromats1855073dichromats
fermate122813003fer_mate
formate123115093for_mate
fromage1336753_fromage
hamate113319833_h_amate
homage121210603_h_omage
humate113214443_h_umate
ostomate1049573ostomate
perorate10417923perorate
phonate12411813ph_onate
phorate12413363ph_orate
primate111516283_primate
probate11414483_probate
prolate9419793_prolate
promote11313143_promote
pronate9418873_pronate
prorate9418733_prorate
ramate83921693__ramate
remate84428683__remate
rotate63320343__rotate
schoolmate1753333schoolmate
shipmate1546153shipmate
sororate8411173sororate
stomate9313123_stomate
stromata1047593stromata
thionate11137503thionate
throat94819753thro_at_
throated1247923thro_ated
throats104612193thro_ats
throaty13428483thro_aty
workmate1744673workmate

Search took 9 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.453394461.4
2DLD Change Limit1461621377.78318779.6
3Display Results1371370.0632174.6
 (SQL Overall)1786911378.29921531.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.