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

112 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
kasher13491503(None) 
basher115123811basher
dasher104318981dasher
gasher104320371gasher
kashers143914021kashers
kosher134412971kosher
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
dashed115920562dashed
dashers115016862dashers
dashes106124982dashes
dashier114311182dashier
easier64218462easier
easter65027982easter
fashed136720252fashed
fashes124524022fashes
faster94625772faster
father125116712father
fisher124917142fisher
flasher133914062flasher
gashed116321972gashed
gashes105725152gashes
gasper94515542gasper
gasser75017772gasser
gaster75027352gaster
gather104115852gather
gusher104115772gusher
harsher13310362harsher
hashed136021942hashed
hashes125024802hashes
jasper154610382jasper
josher164312962josher
kaiser103610372kaiser
kasha124710722kash_a
kashas133311902kashas
kashered1636402kashered
kashmir16162402kashmir
kisser104212452kisser
koshers144811802koshers
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.360496363.9
2DLD Change Limit825511122.53032628.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911122.93660862.1
 
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.