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

99 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
pushers12381450(None) 
bushers124018801bushers
gushers113512511gushers
mushers124016441mushers
pishers123815751pishers
pusher114318281pusher_
pushes114621661pushe_s
rushers103816101rushers
ushers94415531_ushers
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
mashers124621052mashers
moshers124017842moshers
musers84719102mus_ers
musher113820572musher_
mushes114124562mushe_s
musters94522512musters
noshers103614332noshers
ousters74122792ousters
pashes115828392pashe_s
passers94717752passers
pasters94531732pasters
pausers94113222paus_ers
pesters93827092pesters
pisher114317752pisher_
pishes114722102pishe_s
pissers95014752pissers
plashers133813452plashers
plusher124010382plusher_
plushes124313672plushe_s
posers84223972pos_ers
posher115018162posher_
posters93928012posters
pothers123818622pothers
puckers153514672puckers
puffers15349202puffers
pulers83820282pu_lers
pullers93618482pullers
pulpers114612282pulpers
pulsers94213152pulsers
pumpers133113672pumpers
punchers152610072punchers
punishers1434972punishers
punkers133714852punkers
punners94114232punners
punsters103310582punsters
punters93617042punters
purgers104714002purgers
pursers93916092pursers
pursuers10376522pursuers
puses75532202pus_e_s
pushed125017462pushe_d
pushier123611092pushier_
pushovers1743002pushovers
pushups1433652pushups
pusleys12286232pusleys
pusses84322842pusse_s
putters94219192putters
quashers20186802quashers
rashers104020912rashers
rushees103311952rushees
rusher94019652rusher_
rushes94724362rushe_s
shushers14267052shushers
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.376475242.0
2DLD Change Limit107671992.83038046.3
3Display Results99990.0303300.0
 (SQL Overall)178691993.23655219.7
 
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.