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

56 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
emanate9312471emanat_e
emanated1139161emanated
emanates10311331emanates
manatee9317661_manatee
emanative1447312emanative
emanator1047292emanator
manatees10310422_manatees
cyanate12259703cyanat_e
cyanates13238433cyanates
emaciate1248753emaciat_e
emaciated1446933emaciated
emaciates1347883emaciates
emanant9411093emana_nt
emanating1239003emanating
emanation11910783emanation
emanators1147033emanators
emendate1146783emendat_e
emendated1344663emendated
emendates1246083emendates
emirate91015833emirat_e
emirates101214853emirates
emulate9314123emulat_e
emulated11310793emulated
emulates10312573emulates
enate54428153e__nat_e
enates64026433e__nates
geminate11411813geminat_e
geminated1338553geminated
geminates12310043geminates
grantee83217133gran_tee
imamate1138103imamat_e
imamates1237663imamates
khanate1437073khanat_e
khanates1535733khanates
lanate6421263_lanat_e
lanated8313203_lanated
magnate10512703_magnat_e
magnates11511613_magnates
malate84624563_malat_e
malates93522613_malates
manacle11310283_manacle
manage93818903_mana_ge
managed113212603_managed
manager103413583_manager
manages103418963_manages
manat76039993_manat__
manats84623463_manat_s
mandate10315573_mandat_e
mandated12310293_mandated
mandates11314093_mandates
mantel84317973_man_tel
mantes84430783_man_tes
mantle84420923_man_tle
mentee84121293_men_tee
planate9314573planat_e
semanteme1342883seman_teme

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.466383457.1
2DLD Change Limit146162567.28320068.9
3Display Results56560.0301866.7
 (SQL Overall)178691567.77922970.9
 
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.