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

103 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
mushers12401644(None) 
bushers124018801bushers
gushers113512511gushers
mashers124621051mashers
moshers124017841moshers
musers84719101mus_ers
musher113820571musher_
mushes114124561mushe_s
musters94522511musters
pushers123814501pushers
rushers103816101rushers
ushers94415531_ushers
ambushers1643432ambushers
amusers94610192amus_ers
bashers124820832bashers
blushers133911292blushers
brushers134210572brushers
bushels124110712bushels
busher114922202busher_
bushes115226112bushe_s
buskers133414092buskers
busters94724132busters
coshers123618182coshers
crushers134010092crushers
cussers94213402cussers
dashers115016862dashers
dusters84918362dusters
fishers134714722fishers
flushers14279732flushers
fussers104210812fussers
gusher104115772gusher_
gushes104719032gushe_s
hushes124718592hushe_s
huskers143510042huskers
joshers174111592joshers
justers143815732justers
kashers143914022kashers
koshers144811802koshers
lashers104121832lashers
lusher93818762lusher_
lushes94022742lushe_s
lusters73921442lusters
masers84623452mas_ers
masher114123202masher_
mashes115030002mashe_s
maskers133913842maskers
masters94628922masters
meshes115019442meshe_s
misers85025702mis_ers
mishears1338322mishears
misters93927512misters
mithers123516732mithers
mosher114719792mosher_
moshes115222872moshe_s
mossers94116192mossers
mothers123717622mothers
mousers95216442mous_ers
mouthers133811302mouthers
muches134718992muche_s
muckers153612802muckers
mudders113211112mudders
mudhens1335102mudhens
muggers113611932muggers
mullers93217302mullers
mummers103712842mummers
mumpers133311372mumpers
munchers15318772munchers
munsters104010552munsters
murders103311362murders
murthers1336542murthers
muser76024122mus_er_
muses75134302mus_e_s
mushed124420842mushe_d
mushier123813592mushier_
muskegs14285012muskegs
muskets13258642muskets
mussels9419842mussels
musses84624782musse_s
mustees94614922mustees
muster84724522muster_
mutters94117142mutters
noshers103614332noshers
ousters74122792ousters
pishers123815752pishers
pusher114318282pusher_
pushes114621662pushe_s
quashers20186802quashers
rashers104020912rashers
rushees103311952rushees
rusher94019652rusher_
rushes94724362rushe_s
shushers14267052shushers
smashers13339592smashers
smushes123710092smushe_s
tushery1335632tushery
tushes94319472tushe_s
tuskers113710042tuskers
tussers74313562tussers
users55817572_us_ers
usher84517762_usher_
washers134517522washers
wishers133215212wishers
wuthers133711522wuthers

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.373479064.3
2DLD Change Limit1076711032.92336835.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911033.34253468.3
 
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.