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

142 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
wavey14511554(None) 
waney115120321waney
wave105234731wave_
waved125223581waved
waver115025701waver
wavery154610051wavery
waves115633921waves
waveys15597011waveys
wavy136620471wav_y
ave67748702_ave_
aver75931882_aver
aves76142602_aves
cagey115917822cagey
cakey145517272cakey
cave95941262cave_
caved116227562caved
caver105629062caver
caves105639702caves
cavy125920002cav_y
covey136121782covey
daven94916472daven
davy116015522dav_y
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
fakey155515422fakey
fave105532962fave_
faves115331422faves
gamey115320552gamey
garvey13127872garvey
gave84634052gave_
gavel95815182gavel
have106137072have_
haven114718532haven
haver115124462haver
haves116034872haves
hayey144812532hayey
jarvey19135402jarvey
jivey185111872jivey
lacey105820912lacey
lave75642142lave_
laved95028592laved
laver85031792laver
laves86039152laves
mamey125418832mamey
matey107022662matey
maven104816892maven
nave75732312nave_
navel87016572navel
naves87030382naves
navvy14696682navvy
navy107518632nav_y
oaves84925612oaves
pacey126720282pacey
pave96133892pave_
paved115525262paved
paver104225832paver
paves104833922paves
peavey14398792peavey
rave75542092rave_
raved94931432raved
ravel84621512ravel
raven84723442raven
raver85631492raver
raves85441972raves
save75741362save_
saved95127112saved
saver84831252saver
saves85838632saves
savoy114713882savoy
savvy14497502savvy
slavey124011802slavey
wacky174714932wacky
waddy135312992waddy
wade85237062wade_
waded106024752waded
wader95325362wader
wades95634142wades
wady115324992wa_dy
wae67556952wa_e_
waes76048602wa_es
wafer114417642wafer
wafery15398692wafery
wage84834082wage_
waged104822782waged
wager95925052wager
wages95330932wages
waive114214602waive_
waived134511282waived
waiver124212712waiver
waives123714182waives
wake114935702wake_
waked135626752waked
waken124818472waken
waker125526592waker
wakes126633652wakes
wale74546432wale_
waled94330992waled
waler84229262waler
wales86142832wales
wally114625092wally
waly105830902wa_ly
wame95035482wame_
wames106432802wames
wane76344722wane_
waned95831782waned
wanes85040882wanes
wanly115118022wanly
wany106432362wa_ny
ware76254722ware_
wared96339872wared
wares88250582wares
warty119323822warty
wary106740012wa_ry
washy145911842washy
waspy135410992waspy
water84733312water
watery123914492watery
wavers125022472wavers
wavier124613082wavier
wavies125019842wavies
wavily15219482wavily
waxed166018482waxed
waxen154911812waxen
waxer154317482waxer
waxes155825502waxes
waxy175918202wa_xy
way96757662wa__y
weave115218532weave_
weaved133913482weaved
weaver123916612weaver
weaves123616372weaves
whey135018712w_hey
wifey144913672wifey
winey115325432winey
wive105931752wive_
wived125121502wived
wiver115924512wiver
wives115328922wives
wove105624312wove_
woven115215172woven
yawey14458272yawey

Search took 2 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.296603685.8
2DLD Change Limit538001421.54634799.5
3Display Results1421420.0334303.0
 (SQL Overall)1786911421.87595301.9
 
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.