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

78 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
waterman139728(None) 
watermen1377611watermen
cateran9313772cater_an
gateman1057472gate_man
washerman1743002washerman
watchman1844622watchman
waterhen1485302waterhen
watermark1844122watermark
waterway1745562waterway
weatherman1854242weatherman
airman82414223_a_irman
alderman1145193alderman
ataman81013063_at_aman
atman75520143_at__man
axeman1538103_axe_man
barman103519703ba__rman
baseman1138553base_man
batman105214063bat__man
batsman1157993bat_sman
cameraman1542913cameraman
carman103920743ca__rman
caterans10313223cater_ans
caveman1437073cave_man
dalesman1145803dalesman
gamesman1344523gamesman
gatemen1047603gate_men
german9611983__german
hotelman1344103hotelman
intermat101114613intermat
laterad8310843later_ad
lateral7313573later_al
letterman1164243letterman
material10314103material
maternal1047803maternal
merman10513863__merman
motorman1246143motorman
overman12311463_overman
oysterman1443463oysterman
paternal1038333paternal
salesman1047353salesman
statesman1144403statesman
superman12310233superman
talesman1046693talesman
valerian1147123valerian
veteran1039353veter_an
washermen1743383washermen
watchmen1844753watchmen
water84733313water___
waterage1248663waterage
waterbed1436443waterbed
waterbus1345863waterbus
waterdog1344453waterdog
watered113014953water_ed
waterer103314073water_er
waterers112312783waterers
waterfall1544583waterfall
waterhead1644393waterhead
waterhens1574963waterhens
waterier11312083waterier
waterily1438783waterily
watering122316313watering
waterish14310533waterish
waterjet1848293waterjet
waterleaf1543703waterleaf
waterline1249653waterline
waterlog1245043waterlog
waterloo1145723waterloo
watermarks1943663watermarks
watermelon1552223watermelon
waters95030633water__s
waterski1543223waterski
waterways1845093waterways
waterworn1546183waterworn
watery123914493water__y
weathermen1844503weathermen
whaleman1643973whale_man
wheelman1642813wheelman
wireman1237843wire_man

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 Limit146162788.50017195.5
3Display Results78780.0302600.0
 (SQL Overall)178691788.95319958.8
 
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.