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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
liftman124406(None) 
liftmen1234231liftmen
hitman112710222hi_tman
liman75921602li__man
lineman939122lineman
linkman1335392linkman
pitman102412122pi_tman
titman82711002ti_tman
aidman92410623ai_dman
airman82414223ai_rman
atman75520143__atman
batman105214063_batman
birdman1236673birdman
bitmap1235613bi_tmap
boatman1147053boatman
caftan111710123caft_an
dustman1044683dustman
fifteen1343923fifteen
fireman1249333fireman
firman112211343fi_rman
footman1236403footman
hetman112510603_hetman
hitmen11239193hi_tmen
iceman1037853_iceman
kaftan13185823kaft_an
kinsman1335963kinsman
kirkman1243773kirkman
lactean956483lactean
landman1038923landman
lawman11289053l_awman
layman113511303l_ayman
leadman10237843leadman
legman949653l_egman
leman75622603l__eman
lensman937563lensman
liegeman1143343liegeman
lifespan1382493lifespan
lifeway1644273lifeway
lift76942723lift___
lifted104413523lift_ed
lifter93814813lift_er
lifters104313783lifters
liftgate1243413liftgate
lifting113313273lifting
liftoff1243163liftoff
lifts85719063lift__s
ligan67920283li__gan
lignan75510323li_gnan
lima65734133li__ma_
limans84816303li__mans
limas75627633li__mas
limen75426033li__men
limn66527693li__m_n
linemen938633linemen
linesman1046263linesman
linkmen1335363linkmen
linksman1444153linksman
lipoma1046753lipoma_
lipomas1156443lipomas
listen64816813list_en
litai55216363li_t_ai
litany939053li_t_any
litas54923773li_t_as
litmus836323li_tmus
litten64014873li_tten
meatman1137903meatman
milkman1544913milkman
oilman839483oi_lman
outman83115033_outman
pikeman1535523pikeman
pitmans11188743pi_tmans
pitmen102510793pi_tmen
pivotman1542053pivotman
pointman1244803pointman
postman112410043postman
potman102813573_potman
raftsman1344163raftsman
rifleman1343423rifleman
sideman1037973sideman
tinman82411143ti_nman
titan53318173ti_t_an
titian62512663ti_tian
titmen8239883ti_tmen
wingman1336383wingman
wireman1237843wireman
witan83816503wi_t_an

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.406440125.6
2DLD Change Limit134027866.86019537.5
3Display Results86860.0302866.7
 (SQL Overall)178691867.29624491.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.