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 “jasper” 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
jasper15461038(None) 
asper75520431_asper
gasper94515541gasper
japer146218881ja_per
jaspers164310461jaspers
jaspery19405251jaspery
rasper83917331rasper
aper66336232_a_per
asker96418782_asker
aspen75216092_aspen
aspers86220312_aspers
aster55434892_aster
baser74828922bas_er
basher115123812basher
baster85333602baster
camper124722212camper
caper94831622ca_per
capper124421982capper
carper104923632carper
caster85232572caster
clasper113811862clasper
damper114117752damper
dapper114016632dapper
dasher104318982dasher
easier64218462easier
easter65027982easter
faster94625772faster
gaper86125122ga_per
gasher104320372gasher
gasped104814292gasped
gaspers105014132gaspers
gasser75017772gasser
gaster75027352gaster
gawper12499692gawper
grasper10389792grasper
hamper134518652hamper
harper115018402harper
hasped125014442hasped
jabber173713642jabber
jacker194417582jacker
jaeger14397192jaeger
jager134318132ja_ger
jagger154016002jagger
jailer134316682jailer
jammer174014132jammer
jape134923422ja_pe_
japed156217632ja_ped
japers154616172ja_pers
japery18439142ja_pery
japes146322822ja_pes
jauped16457902jauped
jazzer21376502jazzer
jester134319152jester
jimper17389862jimper
josher164312962josher
jumper173612372jumper
juster134617012juster
kasher134915032kasher
lapper104319952lapper
lapser84113142lapser
laser54633322las_er
lasher94824532lasher
laster64830632laster
lisper84114432lisper
mapper124516092mapper
maser75029972mas_er
masher114123202masher
masker124416102masker
master84831342master
napper103718282napper
pamper124316662pamper
paper95128662pa_per
passer84721032passer
paster85734372paster
pauper103511942pauper
raper74932752ra_per
rapper104621572rapper
raser55633412ras_er
rasher95024122rasher
rasped94715202rasped
raspers94415922raspers
raspier93110642raspier
raster64731442raster
sapper103822352sapper
tamper104618512tamper
taper74829772ta_per
tapper104419612tapper
taster64930572taster
vamper134212652vamper
vaster94521022vaster
vesper1138082vesper
warper114015582warper
washer124720392washer
waspier12259052waspier
waster95228942waster
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.343520965.0
2DLD Change Limit82551992.15638289.0
3Display Results99990.0166187.5
 (SQL Overall)178691992.51571050.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.