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

148 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
rasper8391733(None) 
asper75520431_asper
gasper94515541gasper
grasper10389791grasper
jasper154610381jasper
raper74932751ra_per
rapper104621571rapper
raser55633411ras_er
rasher95024121rasher
rasped94715201rasped
raspers94415921raspers
raspier93110641raspier
raster64731441raster
aper66336232_a_per
asker96418782_asker
aspen75216092_aspen
aspers86220312_aspers
aster55434892_aster
baser74828922bas_er
basher115123812basher
baster85333592baster
brasher124515242brasher
brasier94516752brasier
camper124722212camper
caper94831622ca_per
capper124421982capper
carper104923632carper
caster85232572caster
clasper113811862clasper
crapper133913192crapper
crasher124616162crasher
crasser94114342crasser
crisper113511052crisper
damper114117752damper
dapper114016632dapper
dasher104318982dasher
draper94315692dra_per
easier64218462easier
easter65027982easter
eraser64216332eras_er
faster94625772faster
gaper86125122ga_per
gasher104320372gasher
gasped104814292gasped
gaspers105014132gaspers
gasser75017772gasser
gaster75027352gaster
gawper12499692gawper
grasped11409062grasped
graspers11338402graspers
hamper134518652hamper
harper115018402harper
hasped125014442hasped
japer146218882ja_per
jaspers164310462jaspers
jaspery19405252jaspery
kasher134915032kasher
lapper104319952lapper
lapser84113142lapser
laser54633322las_er
lasher94824532lasher
laster64830632laster
lisper84114432lisper
mapper124516092mapper
maser75029972mas_er
masher114123202masher
masker124416102masker
master84831342master
napper103718282napper
pamper124316662pamper
paper95128662pa_per
passer84721032passer
paster85734372paster
pauper103511942pauper
prosper114012192prosper
racer75233022ra_cer
racier85120972racier
racker124824552racker
rafter94517582rafter
raider74318742raider
railer64524932railer
raiser66620102raiser
raker94529792ra_ker
rammer103519652rammer
ramped114617902ramped
ranger73925532ranger
ranker105021902ranker
ranter63826822ranter
rape65041632ra_pe_
raped85334622ra_ped
rapers84327182ra_pers
rapes75740722ra_pes
rapier84019992rapier
rapped114122682rapped
rappee103618672rappee
rappel104211952rappel
rappen103512712rappen
rappers113618442rappers
rarer54731702ra_rer
rase46149982ras_e_
rased65033932ras_ed
rasers64526782ras_ers
rases55447212ras_es
rashers104020912rashers
rashes95330152rashes
rasp66029162rasp__
rasps74316662rasp_s
raspy106511702rasp_y
rasters74629022rasters
rasure6311422rasure
rater54943282ra_ter
rather94319742rather
ratter64326312ratter
raver85631492ra_ver
rawer84623732ra_wer
razer144824272ra_zer
reaper84223142reaper
rester63832432rester
riper74328402r_iper
ripper103518652ripper
riser55431052ris_er
risker105414492risker
roaster74116662roaster
romper104213682romper
roper75431912r_oper
rosier64221262rosier
roster64329082roster
rusher94019652rusher
sapper103822352sapper
tamper104618512tamper
taper74829772ta_per
tapper104419612tapper
taster64930572taster
tramper113812162tramper
trapper113912802trapper
trasher104416132trasher
vamper134212652vamper
vaster94521022vaster
vesper1138082vesper
warper114015582warper
washer124720392washer
waspier12259052waspier
waster95228942waster
wrapper14368332wrapper
yapper133714512yapper
yauper11368542yauper
yawper14437952yawper
zapper193414022zapper

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.330541487.9
2DLD Change Limit825511482.45333653.1
3Display Results1481480.0463217.4
 (SQL Overall)1786911482.82963164.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.