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

238 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
wyvern1536392(None) 
wivern12409281wivern
wyverns16363011wyverns
cavern115312452cavern
govern1036822govern
tavern9428932tavern
waver115025702waver_
wavers125022472wavers
wavery154610052wavery
wiver115924512wiver_
wiverns13366962wiverns
wivers125320802wivers
woven115215172wove_n
adverb12265413adverb
advert103215773advert
aiver85725163aiver_
aivers94822323aivers
astern64815813astern
aver75931883_aver_
avers85127313_avers
avert86029493_avert
casern84713313casern
caver105629063caver_
caverns124510243caverns
cavers115026833cavers
coven106925043cove_n
cover105430773cover_
covers114627963covers
covert114925503covert
cyber124910383cyber_
cyder114611133cyder_
cyders12398833cyders
daven94916473dave_n
decern91310953decern
devein1039143devein
diver94827803diver_
divers105024963divers
divert103922813divert
doven94718553dove_n
dyer85522113dy_er_
dyers96617133dy_ers
dynein1035563dynein
elver85216243elver_
elvers93814983elvers
ern35738353___ern
even75222273_eve_n
ever77027693_ever_
evert84929513_evert
every115215453_every
extern1348473extern
eyen76223663ey_e_n
eyer76127283ey_er_
eyers86521333ey_ers
fern76129323__fern
fever115617953fever_
fevers125414893fevers
fiver116024943fiver_
fivers124420923fivers
given95915283give_n
giver94921203giver_
givers104817713givers
governs1136103governs
gyve116215083gyve__
gyved13568743gyve_d
gyves125711553gyve_s
haven114718533have_n
haver115124463haver_
havers124721483havers
hern76134893__hern
hover115524133hover_
hovers124320253hovers
hymen13311043hyme_n
hyper135213903hyper_
hyperon1548183hyperon
hypers144811913hypers
intern64016543intern
invert94120083invert
jiver155119053jiver_
jivers164515643jivers
kern85326213__kern
klavern1433003klavern
laver85031793laver_
lavers94526363lavers
lever85125163lever_
levers94621323levers
liven85021733live_n
liver85132963liver_
livers94927823livers
livery124910893livery
lover85526453lover_
lovers94223433lovers
lucern846103lucern
maven104816893mave_n
modern939523modern
mover104220863mover_
movers115117193movers
never86218643never_
obvert11412993obvert
oven76624143_ove_n
over77227343_over_
overs85224793_overs
overt85630723_overt
oyer75927653oy_er_
oyers87620883oy_ers
paver104225833paver_
pavers115021823pavers
quern143610403_quern
raven84723443rave_n
raver85631493raver_
ravers94628183ravers
reverb113912573reverb
revere94621253revere
revers94529633revers
revert93529113revert
revery124014213revery
riven85121623rive_n
river85731693river_
rivers94626543rivers
roven85521973rove_n
rover85527373rover_
rovers95423523rovers
saver84831253saver_
savers93825923savers
secern81010223secern
seven84118313seve_n
sever85426053sever_
severe94016083severe
severs94121123severs
silvern10347133silvern
siver85728613siver_
sivers95324153sivers
stern55319123_stern
sweven1235983sweve_n
syren85216743syre_n
taverna10285383taverna
taverns10317803taverns
tern46134803__tern
twyer11558523twy_er_
twyers12497413twy_ers
tyer75323393ty_er_
tyers86220053ty_ers
vein75625753__vein
vera76828843__vera
verb96224873__verb
vert77249373__vert
very108025643__very
vivers124717363vivers
wader95325363wader_
waders109120643waders
wafer114417643wafer_
wafers124316143wafers
wafery15398693wafery
wager95925053wager_
wagers105122203wagers
waiver124212713waiver_
waivers133410053waivers
waken124818473wake_n
waker125526593waker_
wakers134822493wakers
waler84229263waler_
walers94824463walers
warn75239323w__arn
warren95012853warren
water84733313water_
waters95030623waters
watery123914493watery
wave105234733wave__
waved125223583wave_d
wavered142910433wavered
waverer13319523waverer
wavering152410543wavering
waves115633923wave_s
wavey145115543wave_y
waveys15597013waveys
wavier124613083wavier_
waxen154911813waxe_n
waxer154317483waxer_
waxers164014303waxers
wayworn1675293wayworn
wean75734353w__ean
weaver123916613weaver_
weavers133714463weavers
weber10313523weber_
webers11310943webers
wedeln10326693wedeln
ween75835463w__een
weer75535093w_eer_
weever123811443weever_
weevers13379993weevers
wen66249603w__e_n
were76238333w__ere
wert79749823w__ert
western102911093western
wheen115016053w_heen
when105723043w_he_n
where117019423w_here
widen94717973wide_n
wider94826353wider_
wigeon1037223wigeon
winery125014273winery
wiper105421293wiper_
wipers115416083wipers
wirer85124953wirer_
wirers94617893wirers
wiser85522803wiser_
wive105931753wive__
wived125121503wive_d
wives115328923wive_s
wizen175813863wize_n
woken124614973woke_n
wolver12419713wolver_
wolvers13349313wolvers
women104619253wome_n
womera11137593womera
wooer84316693wooer_
wooers93712443wooers
worn75631753w__orn
wove105624313wove__
wovens12449833wovens
wren78221683w_re_n
wrier84521753wrier_
wryer11489303wryer_
wye96331973wy_e__
wyes105727503wy_e_s
wyle105519383wyle__
wyled124611843wyle_d
wyles114615323wyle_s
wyn95921443wy___n
wynn105811293wy__nn
wyte106018643wyte__
wyted12529473wyte_d
wytes114113433wyte_s
yarn75230043_y_arn
yean75834583_y_ean
yearn86316433_yearn
yen66847383_y_e_n
yerk116222083_y_erk
yourn87512773_yourn

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162385.39020912.1
3Display Results2382380.0802975.0
 (SQL Overall)1786912385.61031852.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.