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

97 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
watermen137761(None) 
waterhen1485311waterhen
waterman1397281waterman
gatemen1047602gate_men
washermen1743382washermen
watchmen1844752watchmen
waterbed1436452waterbed
watered113014962water_ed
waterer103314082water_er
waterhens1574962waterhens
waterier11312092waterier
waterjet1848292waterjet
watermelon1552222watermelon
weathermen1844502weathermen
airmen82612353_a_irmen
aldermen1145043aldermen
averment13311603_averment
axemen1547493_axe_men
barmen105418533ba__rmen
basemen1139083base_men
batmen104414303bat__men
batsmen1146883bat_smen
cameramen1544133cameramen
carmen104019343ca__rmen
cateran9313773cater_an
catered103117783cater_ed
caterer92815953cater_er
cavemen1437143cave_men
dakerhen1642423dakerhen
dalesmen1146203dalesmen
determent121312903determent
eateries8324323eateries
gamesmen1345113gamesmen
gateman1057473gate_man
germen9612313__germen
hotelmen1344193hotelmen
interment11419223interment
lateen64014863late__en
lettermen1164283lettermen
materiel10311263materiel
mermen10813813__mermen
motormen1245703motormen
overmen12311803_overmen
oystermen1443743oystermen
salesmen1047253salesmen
sateen63815013sate__en
statesmen1144163statesmen
supermen12311303supermen
talesmen1047013talesmen
tegmen988403__tegmen
termed94816703__termed
termer85717253__termer
wafered14288433wafer_ed
wagered12299333wager_ed
wagerer11328493wager_er
waitered1238763waiter_ed
warden104515513wa__rden
warmed124516893wa__rmed
warmer113816733wa__rmer
warren95012863wa__rren
washerman1743003washerman
wasterie111211593wasterie_
wasteries121115363wasteries
watchman1844623watchman
water84733313water___
waterage1248673waterage
waterages1349393waterages
waterbeds1544883waterbeds
waterbus1345873waterbus
waterdog1344453waterdog
waterers112312793waterers
waterhead1644403waterhead
wateriest12312243wateriest
waterily1438793waterily
watering122316323watering
waterish14310543waterish
waterjets1944463waterjets
waterleaf1543703waterleaf
waterless1238013waterless
waterline1249653waterline
waterlog1245043waterlog
waterloo1145723waterloo
watermark1844133watermark
watermelons1652073watermelons
waters95030633water__s
watershed1644653watershed
waterski1543233waterski
waterway1745563waterway
waterweed1644643waterweed
waterworn1546193waterworn
watery123914493water__y
wavered142910433waver_ed
waverer13319523waver_er
weatherman1854243weatherman
whalemen1644473whale_men
wheelmen1643323wheelmen
wiremen1236903wire_men

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 Filter1786911461620.423422437.4
2DLD Change Limit146162977.93618417.6
3Display Results97970.0462108.7
 (SQL Overall)178691978.40521260.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.