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

200 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
wakames163528(None) 
wakame1535431wakame_
arames84622572_arames
kames115024692__kames
madames12310062madames
takahes1436172takahes
wakes126633652wak__es
wames106432802w__ames
watapes12228382watapes
abamps1236253_abamps
abases85720773_abases
abates85825033_abates
acmes96020653_a_cmes
adages8412953_adages
agamas97413453_agamas
agapes95212413_agapes
agates76121343_agates
agaves104611513_agaves
akees96119243_ak_ees
akenes104817343_akenes
alamos8415003_alamos
alates64833963_alates
alkanes113812933alkanes
almes75126543_a_lmes
amazes175613473_amazes
animes84719593_animes
arame75026623_arame_
awakes135012473_awakes
baases85218013ba_ases
bakes117035373bak__es
balases93815433balases
bayamos1434663bayamos
benames112814603benames
blames105121863_blames
bynames14256243bynames
cakes116037673cak__es
calamus1139243calamus
camases114216343camases
cames97047313__cames
canapes111213083canapes
carafes125015703carafes
caramel11310253caramel
caramels1238803caramels
carates95630613carates
damages11511273damages
dames85435853__dames
defames132812253defames
degames113312623degames
dekares122710873dekares
facades1339033facades
fakes126032483fak__es
fames105735923__fames
flames114723693_flames
frames115119863_frames
galaxes1538873galaxes
games86238553__games
garages9314113garages
gavages1237683gavages
hakeems16394803hakeems
hakes126034303hak__es
hakims1537303hakim_s
hamates122917683hamates
hames106138703__hames
hapaxes1936593hapaxes
jacales16310323jacales
jakes165023643jak__es
kaes85734063__ka_es
kakapos1243673kakapos
kakas85117343kaka__s
kalams12310603kalam_s
kales95730983__kales
kame105728233__kame_
kanes95529373__kanes
karates115617473karates
lakes95737653lak__es
lames75445543__lames
lavages1138603lavages
leakages1334933leakages
macrames1438953macrames
madame1139853madame_
madams11310943madam_s
makars124612633maka_rs
makes115336853mak__es
malates93522603malates
manages103418963manages
naiades838213naiades
names74833363__names
oakums1264153oakum_s
packages17138733packages
pajamas18278153pajamas
palaces114216453palaces
palates93624933palates
panamas113112763panamas
parades104121463parades
paramos113213513paramos
parkades1538273parkades
pavanes123612653pavanes
pikakes1245823pikakes
racemes1139093racemes
radomes10311053radomes
rakees104516973rak_ees
rakes94440353rak__es
ravages1139403ravages
renames92418053renames
sagamen10127503sagamen
sakes95540753sak__es
salamis9313513salamis
sarapes94617743sarapes
savages1139973savages
savates10312953savates
sesames9310743sesames
shames114726223_shames
skates104219403_skates
soakages1336143soakages
swarajes1843743swarajes
takahe1335793takahe_
takas95520683taka__s
takes94437793tak__es
tamales93216153tamales
tames75242013__tames
tankages13217113tankages
taramas9612703taramas
tatamis939723tatamis
taxemes1635853taxemes
twasomes1344333twasomes
uakaris1146633uakaris
ukases10358063_ukases
vacates12312833vacates
wabbles144013993wabbles
wackes154717713wa_ckes
waddies124214753waddies
waddles124314843waddles
wades95634143w__ades
wadies105121203wa_dies
wadmals1335513wadmals
wadmel1235523wa_dmel
wadmels1334303wa_dmels
waes76048603w__a_es
waffies163611443waffies
waffles16329983waffles
waftages15105393waftages
wages95330933w__ages
waggles123812003waggles
wahines133111173wahines
waives123714183wa_ives
wakanda1544013wakanda
wakandas1643413wakandas
wake114935703wak__e_
waked135626753wak__ed
wakeless1536473wakeless
waken124818473wak__en
wakened1546873wakened
wakener1446913wakener
wakeners1535843wakeners
wakens135012043wak_ens
waker125526593wak__er
wakers134822493wak_ers
wakikis1342623wakikis
wales86142833w__ales
walies95324523wa_lies
wallies103320743wallies
waltzes1935953waltzes
wambles143714023wambles
wame95035483w__ame_
wammus13426733wa_mmus
wamus105514683w__amus
wamuses1237023wamuses
wanes85040883w__anes
wangles113416933wangles
wannabes1344473wannabes
wantages12109023wantages
warbles123215563warbles
wares88250583w__ares
warfares1436683warfares
warmed124516893wa_rmed
warmer113816733wa_rmer
warmers124514293wa_rmers
warmest123113033wa_rmest
warms107726853wa_rm_s
warpages1437053warpages
warsles103413643warsles
wartimes1336963wartimes
wasabis1255363wasabis
washes124425493wa_shes
wastages12109753wastages
wastes96224883wa_stes
watape11208483watape_
wataps11248683wata_ps
watches153017373watches
wattages12106783wattages
wattapes1395253wattapes
wattles103814073wattles
waves115633923w__aves
wavies125019843wa_vies
waxes155825503w__axes
weaves123616373w_eaves
wekas123911793weka__s
whales124716943w_hales
whams135515643w_ham_s
wickapes1943703wickapes

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.403443402.0
2DLD Change Limit1340272006.04622167.9
3Display Results2002000.0633174.6
 (SQL Overall)1786912006.51227440.3
 
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.