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

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
lineman93912(None) 
linemen938631linemen
linesman1046251linesman
linkman1335391linkman
cinema1047652cinema_
cinemas1138042cinemas
fireman1249332fireman
iceman1037852_iceman
kinema1236022kinema_
kinemas1336892kinemas
kinsman1335962kinsman
landman1038922landman
leman75622602l__eman
lensman937562lensman
liegeman1143342liegeman
liftman1244062liftman
liman75921602li__man
lineal65616022line_al
linear65113342line_ar
linen55728722line__n
linesmen1046562linesmen
linkmen1335362linkmen
linksman1444152linksman
pikeman1535522pikeman
sideman1037972sideman
tinman82411142tin_man
wingman1336382wingman
wireman1237842wireman
aidman92410623ai_dman
airman82414223ai_rman
alinement1149103alinement
axeman1538103_axeman
baseman1138553baseman
bedeman12168843bedeman
birdman1236673birdman
bondman1238043bondman
caveman1437073caveman
cinerin9313823cinerin
clansman1245813clansman
enema7612743_enema_
enemas8812003_enemas
firemen1238773firemen
firepan1236983firepan
firman112211343fi_rman
foeman11311233_foeman
foreman12312363foreman
freeman1237343freeman
gateman1057473gateman
gleeman1035363gleeman
gunman9299453gun_man
hangman1337813hangman
hanuman1237133hanuman
hiemal11339503hi_emal
hitman112710223hi_tman
icemen1037893_icemen
inhuman1265483_inhuman
inspan837513_inspan
junkman2043173junkman
kinetin11248263kinetin
kinsmen1335653kinsmen
kirkman1243773kirkman
landmen1038553landmen
landsman1156853landsman
laneway1345273laneway
lawman11289053l_awman
layman113511303l_ayman
leadman10237843leadman
lean46345243l__e_an
legman949653l_egman
lemans85316393l__emans
lemon75618183l__emon
lensmen937883lensmen
libelant1048563libelant
liberal9310193liberal
liegemen1144133liegemen
lien45339803li_e__n
lienal63912783li_enal
lifespan1382493lifespan
lifeway1644273lifeway
liftmen1234233liftmen
ligan67920283li__gan
lignan75510323li_gnan
liken911818843like__n
lima65734133li__ma_
limans84816303li__mans
limas75627633li__mas
limen75426033li__men
limn66527693li__m_n
linac7315413lin__ac
lindane839033lin_dane
linden7411453lin_den
line46965573line___
lineage878983lineage
lineament1147843lineament
lineate7815153lineate
linecut997983linecut
lined64934643line__d
linens64818393line_ns
lineny94011443line_ny
liner55938923line__r
liners65428853line_rs
lines57054573line__s
lineup835983line_up
lineups934913lineups
liney87029633line__y
linga66820823lin_ga_
lingam95112353lin_gam
lingams104510193lingams
lingas75116573lin_gas
lingua7509913lingua_
linguae8398413linguae
lingual8379083lingual
liniment1049533liniment
linin58025523lin__in
linksmen1443523linksmen
linn46034593lin___n
linsang835863lin_sang
linum7313823linum__
linums838283linum_s
linuron746513linuron
lipoma1046753lipoma_
lipomas1156443lipomas
literal7613273literal
liven85021733live__n
liveryman1752223liveryman
longan75612363lon_gan
lungan74710213lun_gan
lyncean1292923lyncean
milkman1544913milkman
mineral9312733mineral
minima105512653minima_
minimal114010603minimal
minimax18376013minimax
minivan1245713minivan
minuteman1342163minuteman
minyan1138173min_yan
moneran9311113moneran
moneyman1545223moneyman
nema65522523__nema_
nemas75321573__nemas
ninepin945573ninepin
nonman8412363non_man
oilman839483oi_lman
penman10312323pen_man
pikemen1535333pikemen
pineal84817683pine_al
pineland1145893pineland
pinesap1164723pinesap
pineta85815563pineta_
pitman102412123pi_tman
placeman1445683placeman
plainsman1343193plainsman
pointman1244803pointman
policeman1543263policeman
preman104117453_preman
reinsman1045833reinsman
reman75730153__reman
rifleman1343413rifleman
sandman10310173sandman
sidemen1037943sidemen
sokeman1337263sokeman
swingman1443593swingman
teleman959573teleman
tinea54923163tine_a_
tineal66216163tine_al
tineas64616483tine_as
tinmen82310403tin_men
titman82711003ti_tman
tongman1037573tongman
unman72715423_un_man
vanman1139793van_man
vineal94814743vine_al
vinegar1134613vinegar
winesap1264443winesap
wingmen1336113wingmen
wiremen1236903wiremen

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.406440125.6
2DLD Change Limit1340271766.01322289.5
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.48227567.3
 
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.