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

139 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
tongman103757(None) 
tongmen1037121tongmen
bondman1238042bondman
hangman1337812hangman
longan75612362long_an
nonman8412362non_man
strongman1243742strongman
tinman82411142tin_man
tollman935862tollman
toman75724052to__man
tonga65619692tong_a_
tongas74315522tong_as
townsman1344102townsman
wingman1336382wingman
bagman114613813_bagman
boatman1147053boatman
bogan87519003bo_g_an
bogyman1544933bogyman
bondmen1237893bondmen
bondsman1345693bondsman
boogyman1643093boogyman
bookman15136483bookman
bowman13129853bo_wman
conga85419873cong_a_
congas94417033cong_as
congeal104011683congeal
cowman13910373co_wman
dogma96112463do_gma_
dogmas105011243do_gmas
dolman95312403do_lman
donga76718423dong_a_
dongas84914613dong_as
doorman1037063doorman
eonian6311833eon_ian
flagman13186173flagman
foeman11311233fo_eman
footman1236403footman
foreman12312363foreman
frogman1335873frogman
frontman1344303frontman
gagman103811243_gagman
goodman1135933goodman
gownsman1443453gownsman
gunman9299453gun_man
hangmen1337383hangmen
hanuman1237133hanuman
hogan97817703ho_g_an
hogmane1336343ho_gmane
honan85319773hon__an
ironman936613iron_man
junkman2043173junkman
kinsman1335963kinsman
landman1038923landman
legman949653_legman
lensman937563lensman
lineman939123lineman
linkman1335393linkman
logan68123283lo_g_an
longans84510813long_ans
longhand1344493longhand
lungan74710213lung_an
moneran9311113moneran
moneyman1545223moneyman
morgan9311373morg_an
nonfan948293non_fan
nongame1038183nongame
nongay10169153nong_ay
nonhuman1345303nonhuman
nonmen8412833non_men
oilman839483_oilman
organ6915393_org_an
ottoman946283ottoman
outman83115033_outman
penman10312323pen_man
pointman1244803pointman
postman112410043postman
potman102813573po_tman
ragman94013713_ragman
rodman949713ro_dman
rodsman1036653rodsman
roman75424823ro__man
sandman10310173sandman
snowman12226623snowman
sockman1535663sockman
socman1039813so_cman
sokeman1337263sokeman
soman75024903so__man
sonarman1045563sonarman
soundman1144713soundman
stockman1644143stockman
strongmen1244323strongmen
stuntman1072943stuntman
swagman1334913swagman
swingman1443593swingman
tanga64923693tang_a_
tangram1038073tangram
taximan1635783taximan
taxman15328613t_axman
tegmen988403t_egmen
teleman959573teleman
tinmen82310403tin_men
titman82711003t_itman
toboggan1252183toboggan
toga57027413to_g_a_
togae67020113to_g_ae
togas67823003to_g_as
tokamak1242913tokamak
tokomak1243253tokomak
tolan55124013to__lan
tollmen935733tollmen
tomans85419133to__mans
tonal53724303ton__al
toneme8312103tonem_e
tonemes9311683tonemes
tonemic11310173tonemic
tong56434353tong___
tonged86518903tong_ed
tonger74719683tong_er
tongers84116013tongers
tonging93314513tonging
tongs65928463tong__s
tongue7410093tong_ue
tongued946323tongued
tongues879693tongues
tonguing1046263tonguing
tonneau765913tonneau
toucan838193to_ucan
toughen11329203toughen
townsmen1344073townsmen
turfman1243983turfman
unman72715423_un_man
vanman1139793van_man
wangan10311223wang_an
wingmen1336113wingmen
woman105818003wo__man
woodman1336313woodman
woolman1235433woolman
workman1635613workman
yeggman1442923yeggman

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.423422437.4
2DLD Change Limit1340271396.04622167.9
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.53227356.2
 
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.