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

68 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
menschy1735400(None) 
mensch13387091mensch_
menschen1543702menschen
mensches1536292mensches
mensh105413552mens_h_
meshy135612782me_s_hy
beachy164011253be_achy
beechy16397503be_echy
bench125619503ben_ch_
bunchy16437463bun_chy
conchy163710223con_chy
densely1146713densely
densify1435293densify
density1137583density
descry1256183de_scry
ensky1235093_ens_ky
kench145513923ken_ch_
kitschy1941983kitschy
leachy14419733le_achy
lengthy1452733lengthy
manche133515103man_che
marshy14558333mars_hy
mashy136016503m_as_hy
measly113610443meas_ly
menace103216943menac_e
menaced122710093menaced
menacer112610883menacer
menaces112715523menaces
menarche1545813menarche
meniscal1246193meniscal
menisci1144773menisc_i
meniscus1243773meniscus
mensa75318663mens__a
mensae84114043mens_ae
mensal84615653mens_al
mensas85115853mens_as
mense75025633mens__e
mensed93916543mens_ed
menses84222453mens_es
menshen1236803menshen
menshes12310443menshes
mensing103915103mensing
merch125417963me_rch_
mercy125916183me_rc_y
mescal104113483me_scal
mesh96823003me_s_h_
messily12298813messily
messy104913833me_s_sy
mincy125817413min_c_y
monarchy1843603monarchy
munch124917103mun_ch_
muscly1337453m_uscly
mushy135316633m_us_hy
peachy164510843pe_achy
penoche1447043penoche
penuche1435943penuche
penuchi1444033penuchi
punchy16398523pun_chy
reechy14367823re_echy
sensory10329083sensory
stenchy15256213sten_chy
techy135612013te__chy
tench105620003ten_ch_
tensely1037363tensely
tensity1039103tensity
tetchy1436003te_tchy
wench136214783wen_ch_
yechy16519083ye__chy

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027688.53315706.9
3Display Results68680.0135230.8
 (SQL Overall)178691688.70220534.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.