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

106 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
conflates1431113(None) 
conflate13311171conflate_
conflated1539331conflated
canulates11312872canulates
collates103019142co_llates
conclaves1646542conclaves
conepates13912282conepates
confluxes2143832confluxes
confutes1339842conf_utes
consulates12711102consulates
copulates132612462copulates
corelates11314862corelates
cornflakes1942572cornflakes
inflates11512192_inflates
cannulates1247783cannulates
canulate10314553canulate_
canulated12310673canulated
chelates132713843c_helates
chocolates1746783chocolates
cholates132414763c_holates
coagulates13137453coagulates
cocreates132611883cocreates
coequates2045853coequates
coffles152610003coffl__es
cogitates1247863cogitates
cognates11311583co_gnates
cohobates1646523cohobates
coinmates1348343coinmates
collages113514243co_llages
collate92919683co_llate_
collated113615063co_llated
colocates13312853colocates
comates114123643co__mates
completes153212923completes
conatus9310463con__atus
concaves1538913con_caves
conciliates1546883conciliates
conclave1556403conclave_
concludes1445143concludes
concretes13411473concretes
conepate12712533conepate_
conepatls1385343conepatls
confabs1435393conf_a_bs
confabulates1953493confabulates
confected1739073confected
confects153110873confect_s
conferees14610623conferees
confesses1438623confesses
confidantes1754143confidantes
confides14310573conf_ides
confines13315653conf_ines
confiscates1854043confiscates
confits122811423conf_it_s
conflating16410003conflating
conflation15412083conflation
conflations16411143conflations
conflicted1844053conflicted
conflicts1644793conflicts
confreres1448033confreres
confuses13310363conf_uses
confute1239263conf_ute_
confuted1437683conf_uted
confuter1338513conf_uter
confuters1437793conf_uters
conglobates1653323conglobates
conglobes1444223conglobes
congrats11311433congrat_s
conjugates2044693conjugates
connate9315753con_nate_
connotes10311453con_notes
consulate11612233consulate_
contes84432913con___tes
convolutes1544503convolutes
copemates1549483copemates
copulate122614113copulate_
copulated142710483copulated
corelate10516013corelate_
corelated12411823corelated
coronates1110816923coronates
corotates112714283corotates
correlates1248673correlates
cowflaps1842293cowfla_ps
crenelates1266193crenelates
cumulates13258973cumulates
deflates123013943_deflates
donates83217223don__ates
enflames1357043_enflames
folates103218453fo__lates
inflames1377323_inflames
inflate10312313_inflate_
inflated12410863_inflated
inflater1149893_inflater
inflaters1247543_inflaters
modulates1238053modulates
nonglares1046413nonglares
oblates91913243_o_blates
ovulates1148523_ovulates
oxalates1557063_oxalates
populates132710673populates
reflates113115663_reflates
reinflates13137213reinflates
solates73523853so__lates
sonicates11410383sonicates
sufflates1546033sufflates
tinplates1147773tinplates
toeplates1147183toeplates

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 Limit1486411066.78321913.8
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.24924650.4
 
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.