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

138 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
gavel9581518(None) 
gave84634051gave_
gavels105911091gavels
gravel105313821gravel
navel87016571navel
ravel84621511ravel
agave95314032agave_
agaves104611512agaves
ave67748702_ave_
aver75931882_aver
aves76142602_aves
axel115222072_axel
babel95821692babel
bagel85116792bagel
bevel104517042bevel
camel96822802camel
carvel114817572carvel
cave95941262cave_
caved116227562caved
caver105629062caver
caves105639702caves
cavil103816492cavil
daven94916472daven
devel94217122devel
easel54521112easel
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
fave105532962fave_
favela1237032favela
faves115331422faves
gable85325522gable
gae46457702ga_e_
gaed66031512ga_ed
gaen57329602ga_en
gaes56348032ga_es
gage65936102gage_
gaged85522312gaged
gager74726292gager
gages74529972gages
gal46055512ga__l
gale56347322gale_
galea64722932galea
gales65442482gales
gall56335992ga_ll
game76644322game_
gamed95126392gamed
gamely124711912gamely
gamer84928942gamer
games86238552games
gamey115320552gamey
gane55145302gane_
ganef96322462ganef
ganev95513862ganev
gaol56925412ga_ol
gape75134512gape_
gaped96123532gaped
gaper86125122gaper
gapes86030822gapes
garvey13127872garvey
gases65633992gases
gate55746572gate_
gated75329772gated
gater64533652gater
gates65939512gates
gaveled12399132gaveled
gavial10310082gavial
gavot9321122gavot
gayal9312712gayal
gayer94519192gayer
gaze145032412gaze_
gazed165520332gazed
gazer155720072gazer
gazes155425912gazes
gel45642432g__el
gimel8313352gimel
give85829352give_
given95915282given
giver94921202giver
gives95324872gives
grave94624872grave_
graved114818812graved
gravels113611142gravels
gravely14469062gravely
graven104513522graven
graver105018592graver
graves104624002graves
grovel104310542grovel
gruel66014742gruel
gyve116215082gyve_
gyved13568742gyved
gyves125711552gyves
have106137072have_
haven114718532haven
haver115124462haver
haves116034872haves
hazel176414812hazel
hovel115017682hovel
kevel124213092kevel
label75019382label
lapel73716682lapel
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
level84116552level
marvel113712002marvel
maven104816892maven
naval85315832naval
nave75732312nave_
navels95712692navels
naves87030382naves
novel85615992novel
oaves84925612oaves
panel76023622panel
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
ratel54224882ratel
rave75542092rave_
raved94931432raved
ravels94717072ravels
raven84723442raven
raver85631492raver
raves85441972raves
revel84423162revel
save75741362save_
saved95127112saved
saver84831252saver
saves85838632saves
tael46030712ta_el
travel94112982travel
wave105234732wave_
waved125223582waved
waver115025702waver
waves115633922waves
wavey145115542wavey

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 Filter178691538000.186960704.3
2DLD Change Limit538001383.44015639.5
3Display Results1381380.0761815.8
 (SQL Overall)1786911383.70248268.8
 
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.