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

62 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
bathmat1451014(None) 
bathmats1545931bathmats
bathyal1544822bathyal
batman105214062bat_man
batsman1157992batsman
arhat8327093_arh_at
ashman1148383_ashman
asthma11126563asthma_
asthmas12117363asthmas
ataman81013063_ataman
athwart1348683_athwart
atma68121773_at_ma_
atman75520143_at_man
atmas75721013_at_mas
automat9414873automat
babysat14135233babysat
badman113813843ba_dman
bagman114613813ba_gman
baht96740013ba_h__t
bakemeat1655273bakemeat
bandmate1347973bandmate
barman103519703ba_rman
baseman1138553baseman
bashaw14349303bash_aw
basmati1148233ba_smati
bateau8810563bat_eau
bath95940083bath___
bathe105822883bath__e
bathed125518743bath_ed
bather115322513bath_er
bathers124720363bathers
bathes116524833bath_es
bathing134816243bathing
bathos116215633bath_os
baths105922923bath__s
bathtub1442693bathtub
bathwater1744363bathwater
batmen104414303bat_men
batsmen1146883batsmen
batt65053873bat___t
batteau936343batteau
bayman133712703ba_yman
bitmap1235613bit_map
boatman1147053boat_man
boatsman1245703boatsman
brahma1336193brahma_
brahmas1436733brahmas
bushman1455693bushman
catboat11412243catboat
cathead1338753cathead
cathect1439863cathect
earthman1346473earthman
fathead1437863fathead
gateman1057473gateman
hazmat20312263ha_zmat
patamar1147093patamar
pathway1844853pathway
ratatat7412263ratatat
that75639323__th_at
watchman1844623watchman
yashmac1742563yashmac
yashmak1942743yashmak

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.406440125.6
2DLD Change Limit134027625.97022450.1
3Display Results62620.0134769.2
 (SQL Overall)178691626.38927968.5
 
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.