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

113 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
leman7562260(None) 
lean46345241le_an
legman949651legman
lemans85316391lemans
lemon75618181lemon
liman75921601liman
reman75730151reman
adman84517902adman
atman75520142atman
axeman1538102axeman
axman144813182axman
bean66443862be_an
began86319572began
bema85825252bema_
bemas96424282bemas
bemean10410682bemean
bemoan10310252bemoan
clean75420412cle_an
daman84821162daman
dean56039482de_an
demand104314252demand
demean9510562demean
demon86520312demon
desman9311692desman
dewan95718042dewan
elan46734242_elan
flyman14326422flyman
foeman11311232foeman
german9611982german
glean65818202gle_an
gleeman1035362gleeman
hemal104419802hemal
hemin103620932hemin
hetman112510602hetman
human102716032human
iceman1037852iceman
jean116629282je_an
lagan66520342lagan
lama66635292lama_
lamas75532792lamas
lauan55216792lauan
lawman11289052lawman
layman113511302layman
lea37660182le_a_
lead56038852le_ad
leadman10237842leadman
leaf76441032le_af
leak86233712le_ak
leal46043272le_al
leans55536252le_ans
leant56737782le_ant
leap66032682le_ap
lear47045952le_ar
learn55322662learn
leas45954182le_as
leben7314852leben
legal65715942legal
legmen939342legmen
lemma94811032lemma
lemmas10349162lemmas
lemons84415052lemons
lemony11419552lemony
lemur739772lemur
lensman937562lensman
leva77020712leva_
levant9314492levant
levin84816412levin
ligan67920282ligan
lima65734132lima_
limans84816302limans
limas75627632limas
limen75426032limen
limn66527692lim_n
lineman939112lineman
loan47436452l_oan
logan68123282logan
loran55925092loran
luma65527522luma_
lumas75622912lumas
lumen75220902lumen
man57465852__man
mean65538082me_an
merman10513852merman
nema65522522nema_
nemas75321572nemas
pean66147172pe_an
pecan91919032pecan
pekan111613972pekan
penman10312322penman
preman104117452preman
redan66125012redan
remain85919862remain
remand95618962remand
remans84823002remans
remap95418102remap
reran57329102reran
rewan85623662rewan
roman75424822roman
seaman84015902seaman
sedan65620422sedan
semen75724102semen
sewan85921292sewan
soman75024902soman
teleman959572teleman
toman75724052toman
ulema7109712ulema_
ulemas888962ulemas
unman72715422unman
vegan95114152vegan
wean75734352we_an
woman105818002woman
yean75834582ye_an
yeoman1138822yeoman

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.0931921408.6
2DLD Change Limit538001131.39038705.0
3Display Results1131130.0303766.7
 (SQL Overall)1786911131.513118103.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.