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

431 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
wannest10391500(None) 
tannest72617851tannest
waniest103819111waniest
wanness102610681wanness
anenst63514982_anenst
bannet84925332banne_t
bannets94013842bannets
canniest10313362canniest
dankest122611672dankest
dunnest83312262dunnest
earnest7318732earnest
fainest10417702fainest
funnest102912002funnest
gannet74321852ganne_t
gannets83811442gannets
hangnest12311412hangnest
inanest72115362inanest
lankest112714112lankest
pannes85522852pannes_
rankest112713812rankest
sanest64426692sa_nest
swankest15105932swankest
vainest10315762vainest
wackest164710862wackest
waeness102512782waeness
wanes85040882wa_nes_
wanned104318012wanne_d
wanner94019622wanne_r
wariest105122502wariest
warmest123113032warmest
wattest102412152wattest
waviest134513072waviest
waxiest173510882waxiest
wenniest11259592wenniest
winiest103419692winiest
zaniest163214772zaniest
ablest84721833_ablest
acnes75922623_acnes_
airest63825263_airest
amnesty1244823_amnesty
anapest9311553_anapest
anent54931843_a_nent
anes45255933_a_nes_
angst6415493_a_ngst
annas55824883_annas_
anneal64812293_anneal
annex12310883_anne_x
annexe1337813_annexe
antes56334323_antes_
aptest82917513_aptest
arrest63722633_arrest
attest62618613_attest
awayness1443303awayness
awnless1035923awnless
babiest114414753babiest
baddest112611143baddest
badness1039573badness
baldest102313533baldest
banes74945583ba_nes_
banned94721343banne_d
banner84421503banne_r
banneret102412473banneret
banners94018713banners
banns75321233bann_s_
barest85327693ba_rest
barniest104815053barniest
basest84720493ba_sest
bennes86019013bennes_
bennet84823363benne_t
bennets94712163bennets
blandest113811043blandest
blankest14439063blankest
boniest93318993boniest
bonnes85621453bonnes_
bonnet85524633bonne_t
bonnets94812803bonnets
bonniest10310773bonniest
branniest11199383branniest
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
candent10417363candent
canes75350373ca_nes_
canines93724033canines_
cannas84518403cannas_
canned95022063canne_d
cannel84216403canne_l
cannels93413363cannels
canner84625983canne_r
canners93822663canners
cannery123610013cannery
cannot83616773cann_ot
canoeist10310693canoeist
canoes84725883canoes_
canoness1039393canoness
canonist10513533canonist
canst74932213ca_n_st
carnet84732873carne_t
carnets93918403carnets
congest104618773congest
connect113515743connect
contest93523233contest
crankest1438143crankest
daftest11248943daftest
damndest1276003damndest
dampest12411043dampest
dances95120653dances_
dandiest103415033dandiest
dankness13256693dankness
darkest122512623darkest
darndest1067223darndest
densest83112473densest
donnert82815533donnert
dunness8298983dunness
dwarfest1543473dwarfest
earnests837853earnests
easiest72318773easiest
evenest10312103evenest
fabbest1438033fabbest
faintest1139073faintest
fairest10412293fairest
falsest10310013falsest
fanciest133612713fanciest
fanes84639893fa_nes_
fanjet16311393fanje_t
fanjets1734803fanjets
fanned104117473fanne_d
fanner94218183fanne_r
fanners103914653fanners
fannies103415643fannies_
fantast10311703fantast
farness102912203farness
fastest102413723fastest
fatness103311293fatness
fattest102913063fattest
fawniest14287443fawniest
fenniest113113203fenniest
finest94321733_finest
finniest113011403finniest
fondest11312403fondest
frankest1536963frankest
funest94316863_funest
funfest13348083funfest
funniest113010733funniest
gabfest1336453gabfest
gainst74914693gain_st
gamest94919923ga_mest
gamiest102816223gamiest
garnet73928413garne_t
garnets84115403garnets
gashest114813413gashest
gauntest936603gauntest
gayest104314333ga_yest
gayness1136843gayness
ginniest92610513ginniest
grandest10311573grandest
haddest122711993haddest
halest94823273ha_lest
hances115621283hances_
handiest123417773handiest
handset113016823handset
hangnests1344543hangnests
hanses95022633hanses_
hardest113118413hardest
harness102413933harness
harvest132112753harvest
haziest193313003haziest
honest94822423_honest
inanes62519803inanes_
incest82918743_incest
infest93315433_infest
ingest73119003_ingest
invest93014843_invest
janes124928123ja_nes_
jennet134714953jenne_t
jennets14517633jennets
joannes1436243joannes_
kanes95529373ka_nes_
keenest11410963keenest
kindest12311503kindest
laciest93819033laciest
lakiest113517263lakiest
lamest84722763la_mest
lances84824103lances_
lancet84223573lance_t
lancets93411163lancets
lanes54946793la_nes_
lankiest122912493lankiest
lankness12237043lankness
lanner64920603lanne_r
lanneret82512363lanneret
lanners73618333lanners
largest83715103largest
latest63822703la_test
laxest134913363la_xest
laxness1436043laxness
laziest163814473laziest
leanest7415863leanest
leanness837373leanness
liniest73321153liniest
linnet6419423linne_t
linnets739833linnets
longest84114953longest
luniest73516993luniest
maddest112311213maddest
madness10310073madness
magnet9320663magne_t
magnets10311143magnets
manes76648963ma_nes_
manges94628943manges_
mangiest112815903mangiest
manifest1339503manifest
manless93012933manless
manliest102314943manliest
mannas85019803mannas_
manned94418643manne_d
manner84020513manne_r
mannerist1149103mannerist
manners93417833manners
mannish121710693mannish
mannose939243mannose
manses84225513manses_
mantes84430783mantes_
matiest92522453matiest
mayest114614793ma_yest
maziest183613873maziest
meanest9315703meanest
meanness1037183meanness
naivest10309473naivest
nances83618643nances_
nannies73015203nannies_
nest45548733___nest
oakiest112913923oakiest
onanist7314633onanist
openest9312913openest
paciest112917803paciest
palest83926223pa_lest
paliest93021603paliest
pandect12310953pandect
panes76148693pa_nes_
panne76623653panne__
panned94123433panne_d
panner84224763panne_r
panners93621273panners
patness92912283patness
piniest93121133piniest
pinkest132812623pinkest
plainest10313613plainest
puniest92918093puniest
punkest132611693punkest
punnet83518843punne_t
punnets9409263punnets
punniest102511583punniest
raciest92820013raciest
rainiest81214923rainiest
rances84625443rances_
randiest93418773randiest
ranees64623963ranees_
ranges73826923ranges_
rangiest93115983rangiest
rankness12267943rankness
rarest65725483ra_rest
rashest103916873rashest
rawest93615063ra_west
rawness1038153rawness
renest64529713_renest
rennet64624853renne_t
rennets75212633rennets
runniest82911203runniest
saddest92412383saddest
sadness8310613sadness
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saltest71916513saltest
sandiest93218683sandiest
saneness82313723saneness
sanes55649073sa_nes_
sanies63031953sanies_
sayest94217743sa_yest
scantest101710183scantest
sennet64224143senne_t
sennets73712583sennets
sonnet65923503sonne_t
sonnets74211993sonnets
soonest7415593soonest
sunniest82712913sunniest
swankiest16136203swankiest
swanned11358173swanne_d
swannery1433553swannery
tallest7317093tallest
tamest85721293ta_mest
tangent8314993tangent
tangiest92915223tangiest
tanist6324593ta_nist
tanned75219953tanne_d
tanner63722283tanne_r
tanners74018393tanners
tannery10388663tannery
tannish101610573tannish
tartest72517533tartest
tautest72612443tautest
tawniest11279343tawniest
tennist72813113tennist
tensest72713313tensest
thinnest11248893thinnest
tiniest73020123tiniest
tinniest82911463tinniest
toniest73218903toniest
tonnes65320853tonnes_
trapnest10310923trapnest
twangiest1355223twangiest
twiniest1147153twiniest
unrest62918853_unrest
vaguest1137333vaguest
vainness1136063vainness
vanes85130973va_nes_
vanned104614483vanne_d
vanner94215843vanne_r
vanners103612843vanners
vastest102911513vastest
viniest103216613viniest
wackes154717713wackes_
wackiest172610273wackiest
wades95634143wa_des_
wadies105121203wadies_
wadset10314303wadse_t
wadsets1136443wadsets
waes76048603wa__es_
wages95330933wa_ges_
wahines133111173wahines_
wains86930873wain_s_
waist86132383wa__ist
waives123714183waives_
wakens135012043wakens_
wakes126633653wa_kes_
wales86142833wa_les_
walies95324523walies_
wallet93327093walle_t
wallets103914833wallets
walnut939433waln_ut
walnuts1033843walnuts
wames106432803wa_mes_
wander104423713wande_r
wanders114221333wanders
wands96425483wa_nds_
wane76344723wa_ne__
waned95831783wa_ne_d
waney115120323wa_ne_y
wangles113416933wangles_
wanier93920683wanie_r
wanked144517153wanke_d
wanker134219973wanke_r
wankers144514713wankers
wanks126124483wa_nks_
wannabe1234533wannabe
wannabes1344473wannabes_
wannesses1239233wannesses
wanning113816213wanning
wans76452273wa_n_s_
want76156173wa_n__t
wanted104319723wante_d
wanter94423053wante_r
wanters104420093wanters
wants87932213wa_nts_
wares88250583wa_res_
wariness11313213wariness
warless104015103warless
warmness1337063warmness
warned104018913warne_d
warner93717223warne_r
warners103315563warners
warns87231003warn_s_
wartiest113614643wartiest
washes124425493washes_
washiest14310403washiest
waspiest1338813waspiest
wast75655853wa___st
wastes96224883wastes_
waves115633923wa_ves_
wavies125019843wavies_
waviness1437723waviness
waxes155825503wa_xes_
waxiness1836723waxiness
wayless13308243wayless
weakest1439003weakest
weakness1535353weakness
weariest112914793weariest
weeniest112411213weeniest
weest85026773w__eest
wennish1336243wennish
west75748083w___est
wetness10277723wetness
wettest10239363wettest
whatness1435093whatness
whines125120103whines_
whiniest14298753whiniest
whinniest15245133whinniest
whitest133710113whitest
widest104517003w_idest
wildest113311273wildest
wiliest103416593wiliest
winces114819113winces_
windiest122213233windiest
wines85546863w_ines_
wingiest123214283wingiest
winless103212283winless
winned104017013winne_d
winner94219933winne_r
winners104316913winners
winoes94317013winoes_
winzes184313053winzes_
wiriest103816853wiriest
wisest95016443w_isest
witness103010013witness
woeness1020211543woeness
womanness1444473womanness
wonkiest1538943wonkiest
wonned104012063wonne_d
wonner95114443wonne_r
wonners104312813wonners
wornness1136363wornness
wrest84925433w__rest
wriest94419713w_riest
wrongest1236733wrongest
wryest12429113w_ryest
wryness13113983wryness
wynns11517473wynn_s_
yarest95018913ya_rest
zanies153219673zanies_
zaniness1738663zaniness

Search took 8 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.1401276364.3
2DLD Change Limit1340274316.70319995.1
3Display Results4314310.1562762.8
 (SQL Overall)1786914316.99925530.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.