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 “mensa” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
mensa7531866(None) 
mensae84114041mensae
mensal84615651mensal
mensas85115851mensas
mense75025631mense
mensh105413551mensh
menta74424421menta
mesa67025481me_sa
sensa54117471sensa
amens75624842amens_
ansa45927772_ansa
bens65945702bens_
cense75121402cense
dens55945072dens_
dense65923502dense
ens37245922_ens_
fens76139762fens_
genoa64315822genoa
gens55740072gens_
genua64614152genua
hansa85416782hansa
henna84414042henna
hens75642572hens_
kens85435232kens_
lens46146492lens_
lense54523432lense
mana65341942man_a
manas76240422manas
manga85026192manga
mania75634142mania
manna75522532manna
mans66354532mans_
manse75528222manse
manta75629902manta
masa65034712m_asa
massa75518922massa
means75831222means_
mecca1139932mecca
media84721712media
meds75735362meds_
medusa936292medusa
mega77620872me_ga
megs75530632megs_
mels65941532mels_
mems85931502mems_
men59252842men__
menad85918982menad
mend75334022men_d
mends84927692mends
menial84223032menial
meno66031352men_o
mensch13387082mensch
mensed93916542mensed
menses84222452menses
mental84521602mental
menu65130222men_u
menus75822842menus
mesas76823202me_sas
mesh96823002me_sh
mesne75116292mesne
mess65932432me_ss
messan83912062messan
messy104913832messy
meta65932412me_ta
mews96629332mews_
miens76118302miens_
mina65136912min_a
minas75434112minas
monas74732152monas
mons68152252mons_
muns65535912muns_
myna95815292myn_a
mynas105815232mynas
omens75618962omens_
omenta83411722omenta
penna74520202penna
pens65649642pens_
senna54617982senna
sense55526822sense
tenia55324482tenia
tens45647412tens_
tense55225842tense
vena76126292ven_a
wens76337932wens_
xenia124814772xenia
yens75832262yens_
yenta83917042yenta

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit53800871.92327977.1
3Display Results87870.0302900.0
 (SQL Overall)178691872.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.