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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

176 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
limen7542603(None) 
lien45339801li_en
liken911818841liken
liman75921601liman
lime66244931lime_
limed85426801limed
limens84618031limens
limes75636501limes
limey104721041limey
limn66527691lim_n
linen55728721linen
liven85021731liven
lumen75220901lumen
vimen104114751vimen
admen84516182admen
aidmen92610372aidmen
aimed85626052aimed
aimer75926822aimer
airmen82612352airmen
alien56425582ali_en
aliment9316702aliment
amen66733152_amen
axmen145112272axmen
blimey13468452blimey
cimex16119132cimex
clime95720892clime_
climes104720002climes
daimen92210572daimen
dime76237642dime_
dimer85625602dimer
dimes85833042dimes
dizen155214932dizen
flamen115215992flamen
flymen14387772flymen
gien56330022gi_en
gimel8313352gimel
given95915282given
glime85620192glime_
glimed105312282glimed
glimes94717522glimes
hitmen11239192hitmen
hymen13311042hymen
laden65022192laden
lame66849292lame_
lamed85235292lamed
lament85024942lament
lamer75233702lamer
lames75445542lames
laten54328342laten
lawmen11308592lawmen
laymen113010842laymen
leben7314852leben
legmen939342legmen
leman75622602leman
lemon75618182lemon
liane54720662liane
libel74116102libel
liber74723622liber
lice66045062lice_
lichen114012742lichen
lie38264522li_e_
lied55838092li_ed
lief76036992li_ef
liens56525502li_ens
lier45942462li_er
lies46454192li_es
lieu46534362li_eu
life75433732life_
lifer85822152lifer
liftmen1234232liftmen
ligan67920282ligan
liger65024472liger
like86040842like_
liked104523812liked
likens105613702likens
liker95627062liker
likes96231902likes
lima65734132lim_a
limans84816302limans
limas75627632limas
limb85429382lim_b
limba95414982limba
limbed114513182limbed
limber104316792limber
limbi96513812limbi
limbo95614812limbo
limbs96118942limbs
limby125714072limby
limeys11429272limeys
limier83518722limier
limina83514502limina
liming94021242liming
limit73126342limit
limmer104314792limmer
limned94811472limned
limner84112872limner
limns75718392limns
limo65529732lim_o
limos75320812limos
limp88432492lim_p
limpa97014462limpa
limped114817122limped
limper104117852limper
limpet103518632limpet
limps95522672limps
limy95727712lim_y
lin37967372li__n
linden7411452linden
line46965572line_
lined64934642lined
linemen938632linemen
linens64818392linens
lineny94011442lineny
liner55938922liner
lines57054572lines
liney87029632liney
linin58025522linin
linkmen1335362linkmen
linn46034592li_nn
lion46334442li_on
lipe66839732lipe_
lipin75518892lipin
lippen103911402lippen
lire47845292lire_
listen64816812listen
lite47054542lite_
liter54736342liter
litten64014872litten
live76540992live_
lived95523722lived
livens94314892livens
liver85132962liver
lives86133192lives
loden66621142loden
lomein8410202lomein
loment84021472loment
lumens85013972lumens
lumpen104010662lumpen
men59252852__men
mien65028362mi_en
mime85736402mime_
mimed105622732mimed
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
mizen164815272mizen
nomen75621622nomen
numen74216792numen
oilmen848312oilmen
omen66828182_omen
pitmen102510792pitmen
ramen75625192ramen
rime65138882rime_
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
ripen75619262ripen
risen54621882risen
riven85121622riven
rumen74419502rumen
semen75724102semen
siren54525822siren
slime74925752slime_
slimed94915122slimed
slimes84722042slimes
time66235012time_
timed85223612timed
timer75626042timer
times75630822times
tinmen82310402tinmen
titmen8239882titmen
vixen153010022vixen
widen94717972widen
wizen175813862wizen
women104619252women
yamen104115182yamen

Search took 2 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.313570897.8
2DLD Change Limit538001761.40638264.6
3Display Results1761760.0463826.1
 (SQL Overall)1786911761.765101241.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.