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 “mothers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
mothers12371762(None) 
bothers124317751bothers
mithers123516731mithers
moshers124017841moshers
mother113718641mother_
mothery153710511mothery
mouthers133811301mouthers
others93918001_others
pothers123818621pothers
smothers13349931smothers
aethers103614942aethers
anthers103715202anthers
bathers124720362bathers
botchers153511542botchers
bother115218062bother_
brothers133410832brothers
cithers124315772cithers
coshers123618182coshers
cotters94323442cotters
dithers114016152dithers
doters74423912dot_ers
dotters83715972dotters
emoters94712872emot_ers
ethers94518412_ethers
fathers133916502fathers
frothers14279812frothers
gathers114315072gathers
gophers1338982gophers
joshers174111592joshers
jotters143413802jotters
koshers144811802koshers
lathers104321882lathers
loathers113310442loathers
lotters73921062lotters
mashers124621052mashers
matchers153012432matchers
maters85032392mat_ers
matters94421752matters
meters85625832met_ers
metiers93312842metiers
miters84328782mit_ers
mither114218562mither_
moaners92813552moaners
mobbers133610922mobbers
mockers153812942mockers
mohels115011322mo_hels
mohurs1135932mo_hurs
moilers93615202moilers
molders103315552molders
molters93816972molters
momsers113810842momsers
momzers20367132momzers
mongers104217272mongers
moochers15369122moochers
mooners94015342mooners
mooters93818622mooters
mopers104220372mo_pers
moppers133412462moppers
mosher114719792mosher_
moshes115222872moshe_s
mossers94116192mossers
motels83616892mot_els
motes75944002mot_e_s
motets84216192mot_ets
mothered142310102mothered
motherly16346092motherly
mothier121910212mothier_
moths106021552moth__s
motleys1235682motleys
motors84616602mot_ors
mottes85523692motte_s
mottlers10388182mottlers
mousers95216442mousers
mouther123812812mouther_
movers115117192mo_vers
mowers113219402mo_wers
murthers1336542murthers
mushers124016442mushers
mutters94117142mutters
northers1139332northers
noshers103614332noshers
notchers13279422notchers
noters64021002not_ers
nother93815962nother_
ochers113915302_ochers
other84219102_other_
otters64021512_otters
pother113818852pother_
potherb14358682potherb
potherbs15387122potherbs
potters94024342potters
potzers184010542potzers
rotters74421392rotters
smithers13369792smithers
smoothers14206042smoothers
smother123510212smother_
smothery16296062smothery
soothers113913432soothers
southers114214452southers
tethers103815312tethers
tithers104216732tithers
tochers123413092tochers
toters65026362tot_ers
tother94117142tother_
totters74618732totters
voters95017442vot_ers
wethers135214692wethers
withers134417752withers
wuthers133711522wuthers
zithers193911972zithers

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711102.86037647.2
3Display Results1101100.0462391.3
 (SQL Overall)1786911103.28254445.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.