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

176 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
rasher9502412(None) 
basher115123811basher
brasher124515241brasher
crasher124616161crasher
dasher104318981dasher
gasher104320371gasher
kasher134915031kasher
lasher94824531lasher
masher114123201masher
raser55633411ras_er
rashers104020911rashers
rashes95330151rashes
rasper83917331rasper
raster64731441raster
rather94319741rather
rusher94019651rusher
trasher104416131trasher
washer124720391washer
archer115016242archer
ashed97829772_ashed
ashen87818672_ashen
ashes86230612_ashes
ashier94714832_ashier
ashler9459972_ashler
asker96418782_asker
asper75520432_asper
aster55434892_aster
baser74828922bas_er
bashed126225702bashed
bashers124820832bashers
bashes115631392bashes
baster85333592baster
bather115322512bather
brashes124518462brashes
brashier13389932brashier
brasier94516752brasier
brusher123813002brusher
busher114922202busher
cashed125124352cashed
cashes114729882cashes
cashew144311452cashew
cashier123713322cashier
caster85232572caster
clasher124615512clasher
cosher114819902cosher
crashed134214202crashed
crashers134013232crashers
crashes124618402crashes
crasser94114342crasser
crusher124412322crusher
dashed115920562dashed
dashers115016862dashers
dashes106124982dashes
dashier114311182dashier
easier64218462easier
easter65027982easter
eraser64216332eras_er
fashed136720252fashed
fashes124524022fashes
faster94625772faster
father125116712father
fisher124917142fisher
flasher133914062flasher
fresher132612642fresher
gashed116321972gashed
gashes105725152gashes
gasper94515542gasper
gasser75017772gasser
gaster75027352gaster
gather104115862gather
grasper10389792grasper
gusher104115772gusher
harsher13310362harsher
hashed136021942hashed
hashes125024802hashes
jasper154610382jasper
josher164312962josher
kashers143914022kashers
kosher134412972kosher
laser54633322las_er
lashed105625212lashed
lashers104121832lashers
lashes94831002lashes
laster64830632laster
lather95124362lather
lusher93818762lusher
maser75029972mas_er
mashed125325042mashed
mashers124621052mashers
mashes115030002mashes
masker124416102masker
master84831342master
mosher114719792mosher
musher113820572musher
nosher94616362nosher
pashed125923142pashed
pashes115828392pashes
passer84721032passer
paster85734372paster
pisher114317752pisher
plasher124215032plasher
posher115018162posher
pusher114318282pusher
quasher19198622quasher
racer75233022ra_cer
rachet115028972rachet
racier85120972racier
racker124824552racker
rafter94517582rafter
raider74318742raider
railer64524932railer
raiser66620102raiser
raker94529792ra_ker
rammer103519652rammer
rancher123013632rancher
ranger73925522ranger
ranker105021902ranker
ranter63826822ranter
raper74932752ra_per
raphe104916422raphe_
raphes115117452raphes
rapier84019992rapier
rapper104621572rapper
rarer54731702ra_rer
rase46149982ras_e_
rased65033932ras_ed
rasers64526782ras_ers
rases55447212ras_es
rash76039932rash__
rashest103916872rashest
rashly123410212rashly
rasped94715202rasped
raspers94415922raspers
raspier93110642raspier
rasters74629022rasters
rasure6311422rasure
rater54943282ra_ter
rathe85821922rathe_
ratter64326312ratter
raver85631492ra_ver
ravisher1465462ravisher
rawer84623732ra_wer
razer144824272ra_zer
reacher123718292reacher
reshes94124362reshes
rester63832432rester
richer114015042richer
riser55431052ris_er
risker105414492risker
roaster74116662roaster
rosier64221262rosier
roster64329082roster
rushed104419862rushed
rushee93818772rushee
rushers103816102rushers
rushes94724362rushes
rushier103411972rushier
sashed105622942sashed
sashes94728482sashes
slasher104515332slasher
smasher123911022smasher
swasher134011512swasher
taster64930572taster
thrasher1455742thrasher
trashed113514702trashed
trashers113013642trashers
trashes104119262trashes
trashier113210102trashier
usher84517762_usher
vaster94521022vaster
washed135521502washed
washers134517522washers
washes124425492washes
washier133611152washier
waster95228942waster
wisher123617062wisher

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 Filter178691825510.360496363.9
2DLD Change Limit825511762.62631436.0
3Display Results1761760.0463826.1
 (SQL Overall)1786911763.03258935.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.