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

140 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
dasher10431898(None) 
basher115123811basher
dashed115920561dashed
dashers115016861dashers
dashes106124981dashes
dashier114311181dashier
gasher104320371gasher
kasher134915031kasher
lasher94824531lasher
masher114123201masher
rasher95024121rasher
washer124720391washer
ashed97829772_ashed
ashen87818672_ashen
ashes86230612_ashes
ashier94714832_ashier
ashler9459972_ashler
asker96418782_asker
asper75520432_asper
aster55434892_aster
baser74828922bas_er
bashed126225702bashed
bashers124820832bashers
bashes115631392bashes
baster85333592baster
bather115322512bather
brasher124515242brasher
busher114922202busher
cashed125124352cashed
cashes114729882cashes
cashew144311452cashew
cashier123713322cashier
caster85232572caster
clasher124615512clasher
cosher114819902cosher
crasher124616162crasher
dabber114816962dabber
dabster1036702dabster
dacker134920752dacker
dafter104813342dafter
dagger95017302dagger
daiker115113032daiker
dammer114317932dammer
damner95213432damner
damper114117752damper
dancer94817612dancer
dander811222992dander
danger83722822danger
danker114319662danker
dapper114016632dapper
darer65230792da_rer
darker114718692darker
darner74017302darner
darter75320362darter
dash87031632dash__
dasheen1136392dasheen
dashi95013112dash_i
dashis104414392dashis
dashy125612382dash_y
dater65332312da_ter
dauber94112012dauber
deashed123411302deashed
deashes113313902deashes
diaster82813312diaster
dished114318712dished
dishes104622652dishes
dishier113613402dishier
dither104417682dither
doser66228562dos_er
dosser74417972dosser
duster74919722duster
easier64218462easier
easter65027982easter
fashed136720252fashed
fashes124524022fashes
faster94625772faster
father125116712father
fisher124917142fisher
flasher133914062flasher
gashed116321972gashed
gashes105725152gashes
gasper94515542gasper
gasser75017772gasser
gaster75027352gaster
gather104115852gather
gusher104115772gusher
harsher13310362harsher
hashed136021942hashed
hashes125024802hashes
jasper154610382jasper
josher164312962josher
kashers143914022kashers
kosher134412972kosher
laser54633322las_er
lashed105625212lashed
lashers104121832lashers
lashes94831002lashes
laster64830632laster
lather95124352lather
lusher93818762lusher
maser75029972mas_er
mashed125325042mashed
mashers124621052mashers
mashes115030002mashes
masker124416102masker
master84831342master
mosher114719792mosher
musher113820572musher
nosher94616362nosher
pashed125923142pashed
pashes115828392pashes
passer84721032passer
paster85734372paster
pisher114317752pisher
plasher124215032plasher
posher115018162posher
pusher114318282pusher
quasher19198622quasher
raser55633412ras_er
rashers104020912rashers
rashes95330152rashes
rasper83917332rasper
raster64731442raster
rather94319742rather
rusher94019652rusher
sashed105622942sashed
sashes94728482sashes
slasher104515332slasher
smasher123911022smasher
swasher134011512swasher
taster64930572taster
trasher104416132trasher
usher84517762_usher
vaster94521022vaster
washed135521502washed
washers134517522washers
washes124425492washes
washier133611152washier
waster95228942waster
wisher123617062wisher

Search took 3 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.343520965.0
2DLD Change Limit825511402.47033421.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.85962501.2
 
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.