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 “wavelet” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

201 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
wavelet1331094(None) 
wavelets1436151wavelets
capelet11517072capelet
gaveled12399132gaveled
raveled114113632raveled
raveler104212462raveler
valvelet1445342valvelet
wallet93327092wa_llet
waveless1437482waveless
wavered142910432wavered
waverer13319522waverer
abele76323253_abele_
abeles84719393_abeles
aglet65534143_a_glet
aiglet74224193_aiglet
amulet8419573_amulet
anele55628833_anele_
aneled74719283_aneled
aneles64626293_aneles
anklet105618733_anklet
applet105917433_applet
armlet84118193_armlet
auklet104216833_auklet
avert86029493_ave_rt
avocet11412683_avocet
avoset9315673_avoset
ballet84733973ba_llet
beveled133811123beveled
beveler124010683beveler
bracelet12310693bracelet
cablet104429463ca_blet
callet84536763ca_llet
camlet104426583ca_mlet
capelets1268603capelets
caplet104226813ca_plet
caveat11417723cave_at
cavemen1437143cavemen
caviled1348723caviled
caviler1249063caviler
coverlet13413013coverlet
davened124610073davened
develed123611933develed
eaglet73722583ea_glet
easeled8159853easeled
eyelet9514533_eyelet
favela1237033favel_a
favelas1337023favelas
favella1336173favella
foveolet14107543foveolet
gallet73630853ga_llet
gantlet83616243gantlet
gavel95815183gavel__
gavelled13387363gavelled
gavels105911093gavel_s
graveled13417363graveled
hamlet113722793ha_mlet
harslet10315653harslet
haslet93222713ha_slet
havened14429243havened
havered144011453havered
haverel13397153haverel
hoveled14209293hoveled
javelin17306983javelin
labeled102510563labeled
labeler92310183labeler
lancelet1049473lancelet
lapeled10258893lapeled
laveer94110423lave_er
leveled114010383leveled
leveler10399903leveler
leveret103014003leveret
mallet84433053ma_llet
mantelet10613823mantelet
mantlet93620993mantlet
martlet93419153martlet
marveled1436433marveled
matelot9411573matelot
navel87016573navel__
navels95712693navel_s
navette1036983navette
omelet8317073_omelet
overlet102619033_overlet
palet74650803pa__let
pallet84232653pa_llet
paneled10612573paneled
partlet92720363partlet
paveed12438893pave_ed
pavement1549443pavement
platelet10510733platelet
ravel84621513ravel__
ravelers113310863ravelers
ravelin102211023ravelin
ravelled12419783ravelled
raveller11339263raveller
ravelly13268353ravelly
ravelment1447203ravelment
ravels94717073ravel_s
ravened115012283ravened
ravener104110733ravener
relet54749823__relet
reveled113917753reveled
reveler104116343reveler
rivulet1069723rivulet
sallet63734543sa_llet
samlet84126563sa_mlet
saveloy1334663saveloy
svelte9319753_svelte
swiveled1544163swiveled
tablet84227643ta_blet
tartlet72218483tartlet
traveled12349453traveled
traveler11328433traveler
valet84337873__valet
valvelets1542793valvelets
varlet9423503va_rlet
veldt94819863__veldt
velvet123613753__velvet
wabble133714843wabble_
wabbled153311443wabbled
wabbler143511923wabbler
wabbles144013993wabbles
waddle114715303waddle_
waddled133611643waddled
waddler124010793waddler
waddles124314843waddles
wadset10314303wa_dset
wafered14288433wafered
waffle15369183waffle_
waffled17357523waffled
waffler16377783waffler
waffles16329983waffles
wageless1237173wageless
wagered12299333wagered
wagerer11328493wagerer
waggle113612303waggle_
waggled13389363waggled
waggles123812003waggles
wailed104823593wa_iled
wailer93720323wa_iler
wakeless1536473wakeless
wakened1546873wakened
wakener1446913wakener
wale74546433wa__le_
waled94330993wa__led
waler84229263wa__ler
wales86142833wa__les
walled104021293wa_lled
wallets103914833wa_llets
wamble134415753wamble_
wambled153610753wambled
wambles143714023wambles
wandle105316663wandle_
wangle103817503wangle_
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles
warble113516603warble_
warbled133212163warbled
warbler123211463warbler
warbles123215563warbles
warsle93112923warsle_
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles
wastelot11105733wastelot
watered113014953watered
waterer103314073waterer
waterjet1848293waterjet
wattle94314213wattle_
wattled113610503wattled
wattles103814073wattles
wauled104713963wa_uled
wave105234733wav__e_
waved125223583wav__ed
wavelength2051153wavelength
wavelike1836613wavelike
wavellite1543943wavellite
waveoff1942823waveoff
waver115025703wav__er
waverers14318613waverers
wavers125022473wave_rs
wavery154610053wave_ry
waves115633923wav__es
wavey145115543wav__ey
waveys15597013wave_ys
wavicle1534063wavicle_
wavicles1633783wavicles
wavier124613083wav_ier
wavies125019843wav_ies
waviest134513073waviest
wavily15219483wavil_y
wawled133811703wa_wled
weaseled12175143weaseled
wedeled1237783wedeled
weet75254153w__e_et
welt75547863w__el_t
wheeled14318463wheeled
wheeler13298773wheeler
wiglet105519153w_iglet
willet95124833w_illet
winglet113115983winglet

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272015.90622693.4
3Display Results2012010.0633190.5
 (SQL Overall)1786912016.37528030.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.