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

72 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
emendate114678(None) 
emendated1344661emendated
emendates1246081emendates
edentate947702edentate
emanate9312472eman_ate
emeerate10410102emeerate
emendable1446232emendable
emendator1244242emendator
mandate10315572_mandate
ameerate1039633ameerate
amendable1446053amendable
cementite13147113cementite
crenate93317113cren_ate
dentate8315153_dentate
denudate1046163_denudate
ecaudate1145313ecaudate
edentates1046953edentates
elevate101110373ele_vate
elongate945613elongate
emaciate1248753emaciate
emanated1139163eman_ated
emanates10311333eman_ates
emeerates1149373emeerates
emend86214893emend___
emendating1444613emendating
emendation1346553emendation
emendators1344203emendators
emended11329603emend_ed
emender10649843emend_er
emenders11319033emenders
emending12298893emending
emends95711433emend__s
emeritae1046353emeritae
emeute838533eme__ute
emigrate1149603emigrate
emirate91015833em_irate
empennage1441943empennage
emulate9314123em_ulate
enate54428153__en_ate
endite73817593__endite
enervate1148463enervate
eventuate12104773eventuate
execrate1739653execrate
extenuate1645003extenuate
exudate1537093e_xudate
fecundate1542993fecundate
geminate11411813gemin_ate
inundate946043inundate
mandated12310293_mandated
mandates11314093_mandates
mediate103415213_mediate
menace103216943_men_ace
menage93216543_men_age
mendable131510583_mendable
mensae84114053_mensa_e
metate82720533_me_tate
misdate101413963_misdate
mundane1038073_mundane
pedate93117763_pe_date
pennate93314033_pennate
perennate1147783perennate
phenate12412203phen_ate
predate10616893pre_date
redate74124683_re_date
remediate1247543remediate
sedate73019813_se_date
selenate81712533selen_ate
senate63725173_sen_ate
sensate7311893_sensate
serenate81914883seren_ate
vendace1357363_vendace
venenate1147933venen_ate

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 Limit146162726.98620922.1
3Display Results72720.0302400.0
 (SQL Overall)178691727.43624030.5
 
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.