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

75 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
junkman204317(None) 
junkmen2033631junkmen
gunman9299452gun_man
juryman1943582juryman
linkman1335392linkman
unman72715422_un_man
automan9310883automan
bondman1238043bondman
bookman15136483bookman
bunkmate1643963bunkmate
bushman1455693bushman
busman10310253bu_sman
deskman1444323deskman
dustman1044683dustman
funkia1336343funkia_
funkias1435383funkias
funnyman1652123funnyman
gunmen9348723gun_men
hackman1836433hackman
hangman1337813hangman
hanuman1237133hanuman
human102716033hu__man
huntsman1343863huntsman
jazzman2442553jazzman
junk155121033junk___
junked184311693junk_ed
junker174213653junk_er
junkers184010863junkers
junket173815023junk_et
junkets18377623junkets
junkie17339603junk_ie
junkier18339493junkier
junkies183711693junkies
junking193910073junking
junks164815973junk__s
junky194513233junk__y
junkyard2341753junkyard
junta123713673jun_ta_
juntas134210503jun_tas
jurymen1943133jurymen
kinsman1335963kinsman
kirkman1243773kirkman
landman1038923landman
lensman937563lensman
lineman939123lineman
linkmen1335363linkmen
linksman1444153linksman
lungan74710213lun_gan
milkman1544913milkman
nonman8412363non_man
outman83115033ou_tman
packman1736693packman
penman10312323pen_man
pullman1135403pullman
punka114515483punk_a_
punkah15347093punk_ah
punkas123410673punk_as
punkin123611523punk_in
sandman10310173sandman
sockman1535663sockman
soundman1144713soundman
stuntman1072943stuntman
sunken103511783sunk_en
suntan62613003sun_tan
surfman1236203surfman
tinman82411143tin_man
tongman1037573tongman
truckman1643153truckman
turfman1243983turfman
unban72114333_un_ban
unhuman1264173_unhuman
unmans82211993_un_mans
vanman1139793van_man
wingman1336383wingman
workman1635613workman

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 Limit134027756.67020094.0
3Display Results75750.0332272.7
 (SQL Overall)178691757.12625075.9
 
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.