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

134 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
liftmen123423(None) 
liftman1244061liftman
fifteen1343922fifteen
hitmen11239192hi_tmen
lifted104413522lift_ed
lifter93814812lift_er
limen75426032li__men
linemen938632linemen
linkmen1335362linkmen
listen64816812list_en
litten64014872li_tten
pitmen102510792pi_tmen
titmen8239882ti_tmen
aidmen92610373ai_dmen
airmen82612353ai_rmen
batmen104414303_batmen
birdmen1235833birdmen
bitten84715123bi_tten
bitumen1134503bitumen
boatmen1146913boatmen
dustmen1035773dustmen
fifteens1442753fifteens
fifties132111083fifties
firemen1238773firemen
fitment12710303fi_tment
footmen1246583footmen
gifted114510703gift_ed
giftee103512083gift_ee
giftees11306513giftees
glisten8418083glist_en
hitman112710223hi_tman
icemen1037893_icemen
kinsmen1335653kinsmen
kirkmen1232923kirkmen
kitten104611483ki_tten
landmen1038553landmen
lateen64014863l_ateen
laten54328343l_at_en
latten65018203l_atten
lawmen11308593l_awmen
laymen113010843l_aymen
leadmen10277903leadmen
lefter93613433left_er
lefties10312073lefties
legmen939343l_egmen
lensmen937883lensmen
lenten6312883lent_en
lichen114012743li_chen
liegemen1144133liegemen
lien45339803li___en
life75433733lif__e_
lifer85822153lif__er
lifetime1343983lifetime_
lifetimes1444153lifetimes
lift76942723lift___
lifters104313783lifters
lifting113313273lifting
liftoff1243163liftoff
lifts85719063lift__s
ligament1149313ligament
lighten112811523lighten
liken911818843li__ken
lilted73715373lilt_ed
liman75921603li__man
lime66244933li__me_
limed85426803li__med
limens84618033li__mens
limes75636503li__mes
limey104721043li__mey
limmer104314793li_mmer
limn66527693li__m_n
linden7411453li_nden
lineman939123lineman
linen55728723li__nen
linesmen1046563linesmen
liniment1049533liniment
linkman1335393linkman
linksmen1443523linksmen
linted74021823lint_ed
lintel64013993lint_el
linter64625343lint_er
lintier73613803lintier
lippen103911403li_ppen
listed74322833list_ed
listee64223063list_ee
listees73416673listees
listel64214743list_el
listens74014133list_ens
lister64527253list_er
lite47054543li_t_e_
liter54736343li_t_er
lithe84922013li_the_
lither94520953li_ther
litmus836323li_tmus
litre55421463li_tre_
litres65220393li_tres
litter64324853li_tter
little63312163little_
littler7348553littler
littles73212783littles
liven85021733li__ven
lofted103811893loft_ed
lofter94614723loft_er
loftier1037763loftier
lumen75220903l__umen
meatmen1138243meatmen
milkmen1565213milkmen
mitten83914093mi_tten
niftier10328713niftier
nifties102612503nifties
often84611413_oft_en
oilmen848313oi_lmen
ointment1069233ointment
pikemen1535333pikemen
pitman102412123pi_tman
pivotmen1542653pivotmen
pointmen1245423pointmen
postmen113110423postmen
potmen102713093_potmen
raftsmen1343953raftsmen
riflemen1344243riflemen
rifted104115313rift_ed
sidemen1037943sidemen
sifted104313673sift_ed
sifter94516233sift_er
sitten64113823si_tten
sixteen1434113sixteen
soften9429493soft_en
tinmen82310403ti_nmen
titman82711003ti_tman
vimen104114753vi__men
wiftier13297733wiftier
wingmen1336113wingmen
wiremen1236903wiremen

Search took 8 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.423422437.4
2DLD Change Limit1340271347.09318895.7
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.56223630.1
 
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.