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

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
rushers10381610(None) 
brushers134210571brushers
bushers124018801bushers
crushers134010091crushers
gushers113512511gushers
mushers124016441mushers
pushers123814501pushers
rashers104020911rashers
rushees103311951rushees
rusher94019651rusher_
rushes94724361rushe_s
ushers94415531_ushers
bashers124820832bashers
blushers133911292blushers
brusher123813002brusher_
brushes124014662brushe_s
bushels124110712bushels
busher114922202busher_
bushes115226112bushe_s
buskers133414092buskers
busters94724132busters
coshers123618182coshers
crashers134013232crashers
crusher124412322crusher_
crushes124215132crushe_s
cussers94213402cussers
dashers115016862dashers
druthers1275792druthers
dusters84918362dusters
fishers134714722fishers
flushers14279732flushers
fussers104210812fussers
gusher104115772gusher_
gushes104719032gushe_s
hushes124718592hushe_s
huskers143510042huskers
joshers174111592joshers
justers143815732justers
kashers143914022kashers
koshers144811802koshers
lashers104121832lashers
lusher93818762lusher_
lushes94022742lushe_s
lusters73921442lusters
mashers124621052mashers
moshers124017842moshers
musers84719102mus_ers
musher113820572musher_
mushes114124562mushe_s
musters94522512musters
noshers103614332noshers
ousters74122792ousters
pishers123815752pishers
pusher114318282pusher_
pushes114621662pushe_s
quashers20186802quashers
rasers64526782ras_ers
rasher95024122rasher_
rashes95330152rashe_s
raspers94415922raspers
rasters74629022rasters
reshes94124362reshe_s
resters74130402resters
risers64624782ris_ers
riskers114011992riskers
rosters73727552rosters
roughers12329182roughers
rousers75220142rous_ers
rousters84315682rousters
rubbers113913192rubbers
ruches114819582ruche_s
rudders93210652rudders
ruers515019412ru__ers
ruggers94612312ruggers
ruiners74213022ruiners
rulers64317092ru_lers
rummers113513652rummers
runners74212452runners
ruses56136582rus_e_s
rushed104419862rushe_d
rushee93818772rushe_e
rushier103411972rushier_
russets738162russets
rustlers8339852rustlers
shushers14267052shushers
trashers113013642trashers
trussers8348282trussers
trusters83112262trusters
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.360496363.9
2DLD Change Limit107671973.47031029.1
3Display Results97970.0303233.3
 (SQL Overall)178691973.86046293.0
 
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.