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

194 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
tongmen103711(None) 
tongman1037551tongman
bondmen1237892bondmen
hangmen1337372hangmen
nonmen8412832non_men
strongmen1244322strongmen
tegmen988402t_egmen
tinmen82310392tin_men
tollmen935732tollmen
toneme8312102toneme_
tonemes9311682tonemes
tonged86518902tong_ed
tonger74719682tong_er
tongue7410092tongue_
tongued946322tongued
tongues879692tongues
toughen11329202toughen
townsmen1344072townsmen
wingmen1336102wingmen
agnomen1036763agnomen
atonement1149053atonement
bagmen115412533_bagmen
boatmen1146913boatmen
bogymen1534763bogymen
bondman1238043bondman
bondsmen1345473bondsmen
bonged105719603bong_ed
bongoes104314113bongoes
boogymen1643103boogymen
bookmen15126263bookmen
bowmen1399853bo_wmen
cognomen1346083cognomen
condemn1237113condemn
congaed11399743congaed
conge85227593cong_e_
congee96024463cong_ee
congeed113212313congeed
congees103517923congees
conger95024273cong_er
conges94928173cong_es
congoes103617303congoes
contemn1137803contemn
cowmen13810923co_wmen
dolmen93911373do_lmen
dongle83612493dongle_
dongles93212873dongles
doormen1036753doormen
flagmen13226913flagmen
foemen11310523fo_emen
footmen1246583footmen
foramen12310533foramen
foremen12412923foremen
frogmen1335893frogmen
frontmen1344423frontmen
gagmen103910413_gagmen
gonged97115913gong_ed
goodmen1135623goodmen
gownsmen1443373gownsmen
gunmen9348723gun_men
hangman1337793hangman
hongied12308163hongied
hongies112716473hongies
ionogen837123ionogen
ionomer939833ionomer
ironmen936453iron_men
junkmen2033633junkmen
kinsmen1335653kinsmen
landmen1038553landmen
legmen939343_legmen
lensmen937883lensmen
linemen938633linemen
linkmen1335363linkmen
lodgment1245983lodgment
longan75612363long_an
longe66626463long_e_
longed87121373long_ed
longer75823193long_er
longes75925573long_es
longies82916553longies
moneymen1545653moneymen
monger94418333mong_er
mongoe94214983mongoe_
mongoes103415713mongoes
mongrel1036333mongrel
monomer11311893monomer
monument1289903monument
morgen9312203morg_en
nomen75621623__nomen
nongame1038173nongame_
nongreen945513nongreen
nonman8412363non_man
numen74216793__numen
oilmen848313_oilmen
omen66828183_o__men
pangen94115913pang_en
penmen10311493pen_men
pointmen1245423pointmen
ponged105619353pong_ed
pongee94920193pong_ee
pongees104212543pongees
postmen113110423postmen
potmen102713093po_tmen
ragmen93712183_ragmen
rodmen939713ro_dmen
rodsmen1035833rodsmen
rontgen835173rontgen
roughen11338833roughen
sandmen1039413sandmen
snowmen12246153snowmen
sockmen1535453sockmen
socmen1039193so_cmen
sokemen1337053sokemen
sonarmen1045253sonarmen
soundmen1145233soundmen
stockmen1643923stockmen
strongman1243733strongman
stuntmen1053703stuntmen
swagmen1334973swagmen
swingmen1443483swingmen
tanged84622493tang_ed
tangent8314993tang_ent
tangier83013903tangier
tangle74019953tangle_
tangled94214633tangled
tangler83515073tangler
tangles83920043tangles
tangoed9318833tangoed
taximen1644923taximen
taxmen15367443t_axmen
tegumen10105423tegumen
telemen9310173telemen
tenement10412593tenement
tenge65720433teng_e_
thonged12376833thong_ed
tinge64626613ting_e_
tinged84220793ting_ed
tinges74722323ting_es
tingle74319053tingle_
tingled93712793tingled
tingler83613323tingler
tingles83818313tingles
tinman82411123tin_man
titmen8239883t_itmen
togae67020113to_gae_
togaed84711343to_gaed
togged95117513to_gged
toggle83810873toggle_
toggled10428653toggled
toggler9399193toggler
toggles93710973toggles
togue64816303to_gue_
togues76014243to_gues
token95419313to__ken
tollman935863tollman
toman75724053to__man
tome67543193to__me_
tomes76037383to__mes
tommed113310143to_mmed
tone46953743ton__e_
toned65435343ton__ed
tonemic11310163tonemic
toner55336243ton__er
tones56048663ton__es
toney86027413ton__ey
tong56434353tong___
tonga65619683tong__a
tongas74315513tong_as
tongers84116013tongers
tonging93314513tonging
tongs65928463tong__s
tonguing1046263tonguing
tonier65520713ton_ier
tonlet62924703ton_let
tonne54921433ton_ne_
tonner64819203ton_ner
tonnes65320853ton_nes
tontine72316143tontine
tonuses73612193tonuses
torment9316173to_rment
torten65314353to_rten
toughed123511693toughed
toughens12286723toughens
tougher114210983tougher
townsman1344093townsman
tungsten943053tungsten
turfmen1244163turfmen
twiggen12333503twiggen
vanmen1138403van_men
wingman1336363wingman
women104619253wo__men
woodmen1356053woodmen
woolmen1234973woolmen
workmen1635933workmen
yeggmen1442673yeggmen

Search took 9 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.1561145455.1
2DLD Change Limit1340271948.21616312.9
3Display Results1941940.0633079.4
 (SQL Overall)1786911948.43521184.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.