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

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

127 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
linkman133539(None) 
lineman939121lineman
linkmen1335361linkmen
linksman1444151linksman
junkman2043172junkman
kinsman1335962kinsman
kirkman1243772kirkman
landman1038922landman
lensman937562lensman
liftman1244062liftman
liman75921602li__man
linemen938632linemen
linesman1046252linesman
linksmen1443522linksmen
milkman1544912milkman
tinman82411142tin_man
wingman1336382wingman
aidman92410623ai_dman
airman82414223ai_rman
birdman1236673birdman
bondman1238043bondman
bookman15136483bookman
cinema1047653cinema_
cinemas1138043cinemas
clansman1245813clansman
deskman1444323deskman
einkorn1144223einkorn
fireman1249333fireman
firman112211343fi_rman
gunman9299453gun_man
hackman1836433hackman
hangman1337813hangman
hanuman1237133hanuman
hitman112710223hi_tman
iceman1037853_iceman
inhuman1265483_inhuman
inspan837513_inspan
junkmen2033633junkmen
kinema1236023kinema_
kinemas1336893kinemas
kinsmen1335653kinsmen
kirkmen1232923kirkmen
landmen1038553landmen
landsman1156853landsman
lawman11289053l_awman
layman113511303l_ayman
leadman10237843leadman
legman949653l_egman
leman75622603l__eman
lensmen937883lensmen
liegeman1143343liegeman
liftmen1234233liftmen
ligan67920283li__gan
lignan75510323li_gnan
liken911818843li_k_en
lima65734133li__ma_
limans84816303li__mans
limas75627633li__mas
limen75426033li__men
limn66527693li__m_n
linac7315413lin__ac
lindane839033lin_dane
linden7411453lin_den
lineal65616023lin_eal
linear65113343lin_ear
linen55728723lin__en
linesmen1046563linesmen
linga66820823lin_ga_
lingam95112353lin_gam
lingams104510193lingams
lingas75116573lin_gas
lingua7509913lingua_
linguae8398413linguae
lingual8379083lingual
liniment1049533liniment
linin58025523lin__in
link86943443link___
linkage1295963linkage
linkboy1643173linkboy
linked114518213link_ed
linker104321473link_er
linkers114317713linkers
linking123818253linking
links96430193link__s
linksland1452053linksland
linkup1245123link_up
linkups1333633linkups
linky127622383link__y
linn46034593lin___n
linsang835863lin_sang
linum7313823linum__
linums838283linum_s
linuron746513linuron
lipoma1046753lipoma_
lipomas1156443lipomas
longan75612363lon_gan
lungan74710213lun_gan
lyncean1292923lyncean
milkmen1565213milkmen
minima105512653minima_
minimal114010603minimal
minimax18376013minimax
minivan1245713minivan
minyan1138173min_yan
nonman8412363non_man
oilman839483oi_lman
packman1736693packman
penman10312323pen_man
pikeman1535523pikeman
pinken124513283pink_en
pitman102412123pi_tman
plainsman1343193plainsman
pointman1244803pointman
reinsman1045833reinsman
sandman10310173sandman
sideman1037973sideman
sockman1535663sockman
stickman1643943stickman
swingman1443593swingman
tinmen82310403tin_men
titman82711003ti_tman
tongman1037573tongman
unman72715423_un_man
vanman1139793van_man
wingmen1336113wingmen
wireman1237843wireman
workman1635613workman

Search took 7 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.390458182.1
2DLD Change Limit1340271275.82623005.0
3Display Results1271270.0502540.0
 (SQL Overall)1786911276.26628517.6
 
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.