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

385 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
ananke103828(None) 
anankes1138761anankes
alane56135612alan_e
andante8311272andante
awake125014782awa_ke
inane52820342inan_e
nance74721842_nance
snake94821112sna_ke
aback134816173aback_
abaka114313823aba_ka
abase76023483aba_se
abate76627843aba_te
acne66625873a_cn_e
adage7414053ada_ge
adnate72913483adna_te
advance1346043advance
agapae9388043agapae
agape85614843aga_pe
agate66525153aga_te
agave95314033aga_ve
agaze156113663aga_ze
agene65621583agen_e
agnate73314883agna_te
agone65924553agon_e
akene95818663aken_e
alack114820063alack_
alae45643753ala__e
alan46844083alan__
aland65526413alan_d
alands75418373alands
alang66023513alan_g
alanin6317273alanin
alanine7316863alanine
alans55636173alan_s
alant55742293alan_t
alants67722023alants
alanyl955483alanyl
alaska1036713alaska
alate55340323ala_te
alike95523963a_like
aline57243153alin_e
alkane104313323alkan_e
alone55732963alon_e
alsike1047913alsike
amaze166016603ama_ze
amine75835383amin_e
ana39559833ana___
anabas8314083anabas
anadem939183anadem
anagoge9166643anagoge
anal48037523ana__l
anally9513503anally
analog7159973analog
analyse10208893analyse
analyte10158813analyte
analyze19167013analyze
anarch11310393anarch
anas46649863ana__s
anatase738943anatase
anatto6139913anatto
ancone83916953ancone
andantes9310853andantes
ane37866953__an_e
anele55628833an_ele
anenst63514983anenst
anent54931843anen_t
angle64528873an_gle
anile54634463an_ile
anime75423203an_ime
anise55129703an_ise
ankh111114413__ankh
ankle95220253an_kle
anlace82513923anlace
anlage72514233anlage
anna45529013an_n_a
annal56520763an_nal
annals66415923annals
annas55824883an_nas
annates72415423annates
annex12310883an_nex
annexe1337813annexe
annoy869713an_noy
annul55813383an_nul
anode65021043an_ode
anole55330383an_ole
anomie83215963anomie
anon46134853anon__
anonym1136383anonym
ansae55720973an_sae
ansate64517863ansate
antae56828293an_tae
ante46538903__ante
antinuke1246493antinuke
antlike11312073antlike
antre55224523an_tre
anyone94612733anyone
apace94718383apa_ce
apache134210773apache
apanage1036803apanage
arable81821003arable
arak86929573ara_k_
araks94820883ara_ks
arame75026623ara_me
arcane81216743arcan_e
arene55329413aren_e
arrange838683arrange
asana5315483asan_a
asanas6514113asanas
askance1345923askance
atone56527983aton_e
avant86224663avan_t
avenge1087553avenge
avenue957953avenue
awaked14579203awa_ked
awaken13468863awa_ken
awakes135012473awa_kes
aware86420023awa_re
awoke124912003a_woke
axlike17388853axlike
axone125918473axon_e
azan136521783azan__
azans146516883azan_s
azine146721413azin_e
bake105637513_ba_ke
balance11510263balance
banana83213413banan_a
bananas93312223bananas
bane65250433_ban_e
bank105835753_bank_
banked135021443_banked
banker124222733_banker
banks115527903_banks
beanie83618593beanie
blank115418553blank_
blanked144011223blanked
blanker134612023blanker
blanket134313093blanket
blanks124112893blanks
brake116025343bra_ke
brank115222283brank_
branks124817383branks
cake105439963_ca_ke
canape10913513cana_pe
cane66653123_can_e
canine83826703canin_e
canker124422523_canker
cannie83819363can_nie
canoe75627253_canoe
chance134617093chance
change124116753change
clank114719523clank_
clanked143812253clanked
clanks124615183clanks
clanky15469073clanky
crake114823523cra_ke
crane75331603cran_e
crank114819613crank_
cranked143812843cranked
cranker133612783cranker
crankle133610063crankle
cranks125015313cranks
cranky153910633cranky
dance85223133_dance
dank95828243_dank_
danker114319663_danker
drake104918303dra_ke
drank104816203drank_
enable83318483enable
enate54428153ena_te
enhance1239693enhance
fake115534943_fa_ke
fane75343573_fan_e
fanlike142610503fanlike
fiance11310743fiance
finance1238573finance
flake125119973fla_ke
flange103411973flange
flank124618093flank_
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flanks133913403flanks
frank124417513frank_
franked153610053franked
franker143510183franker
franks134912733franks
ganache1346203ganache
gane55145303_gan_e
glance94312313glance
grange83716203grange
hake115637843_ha_ke
hance105424153_hance
hank115134143_hank_
hanked144220603_hanked
hanker134622093_hanker
hankie133915713_hankie
hanks126226863_hanks
hanky155418293_hanky
hanse85722793_hanse
inaner62213543inaner
inanes62519803inanes
infante101910883infante
innage73011573innage
innate63917313innate
insane6314883insan_e
intake10510863intake
invoke1336213invoke
jake155925773_ja_ke
jane115031483_jan_e
jnana12159043jnan_a
jnanas13207303jnanas
kanaka9357523kana_ka
kane85133973_kan_e
karaoke1044903karaoke
knack104311043knack_
knacked13287793knacked
knacker12307913knacker
knacks11428543knacks
knave12389463kna_ve
knawe12397883kna_we
lake85741603_la_ke
lanate6421263lana_te
lance75126723_lance
lane45153333_lan_e
lank84734453_lank_
lanker104123003_lanker
lanky125517483_lanky
latke94817093_latke
liane54720663lian_e
make105537893_ma_ke
manacle11310283manacle
manage93818903mana_ge
manana84816073manan_a
mananas93414733mananas
manatee9317663manatee
mane65052033_man_e
mange84930193_mange
manlike133012783manlike
manse75528233_manse
meanie83718393meanie
minke115421763_minke
naan47621933naan__
naans55815253naan_s
nabe66029493_na_be
nacre75715363_nacre
nae35952743_na__e
naive85116213_naive
naked105320853_na_ked
name65637413_na_me
nan37854883_nan__
nana46632903_nan_a
nanas55928633_nanas
nances83618643_nances
nancy105214923_nancy
nankeen1135043_nankeen
nankin1039673_nankin
nannie63713223nannie
nanny84813813_nanny
nans46139403_nan_s
nape65230803_na_pe
nappe96114993_nappe
nark85230063_nark_
narked114116743_narked
narks96026033_narks
narky126017803_narky
nave75732313_na_ve
nene45932063_nen_e
nine45842173_nin_e
nonce75719823_nonce
none45743173_non_e
nuance859043nuance
nuke85920753_n_uke
orange74016323orange
panache1458423panache
pancake1536673pancake
pane64950293_pan_e
panne76623653_panne
pavane114113443pavan_e
penance11313443penance
plane74929143plan_e
plank115221143plank_
planked143512283planked
planks124116753planks
prance104318573prance
prank115019453prank_
pranked143712093pranked
pranks124814723pranks
quake184114643qua_ke
rake84841573_ra_ke
rance75028513_rance
ranee55438103_ranee
range64728413_range
rank85135533_rank_
ranked114620743_ranked
ranker105021903_ranker
rankle103414883_rankle
ranks95225733_ranks
ranpike1335933ranpike
sake85244963_sa_ke
sane45954343_san_e
sank85236833_sank_
seance83716683seance
shake124726403sha_ke
shank125422193shank_
shanked153212123shanked
shanks135315583shanks
skank84415583skank_
skanked11338103skanked
skanker10268483skanker
skanks94710833skanks
skanky12476963skanky
slake93724053sla_ke
slank95822773slank_
snack114718063snack_
snacked144013113snacked
snacker133112603snacker
snacks124514553snacks
snaked115017593sna_ked
snakes103919603sna_kes
snakey135011273sna_key
snaky125113913sna_ky
snare54429983sna_re
snark95419943snark_
snarks104815733snarks
snarky134210843snarky
snathe94415113snathe
sonance9310313sonance
spake114322743spa_ke
spank115919573spank_
spanked143111733spanked
spanker133612353spanker
spanks124514123spanks
stake95927533sta_ke
stance84316913stance
stane55933003stan_e
stank95823303stank_
stanks104917703stanks
swank125318233swank_
swanked15359543swanked
swanker14369483swanker
swanks134811563swanks
swanky16447973swanky
take84739263_ta_ke
tank85134023_tank_
tanka93817483_tanka
tanked113919293_tanked
tanker104521123_tanker
tanks94624733_tanks
tannage8209583tannage
tannate71813523tannate
thane86122533than_e
thank125817803thank_
thanked15469153thanked
thanker14309593thanker
thanks134313133thanks
trance84718763trance
trank96222423trank_
tranks104017763tranks
twanky16445773twanky
unable83819223unable
unalike11311533unalike
unasked122010023unasked
unawake1445343unawake
uncake122813523uncake
unlike102614063unlike
unmake122811213unmake
unranked1338563unranked
unyoke1367293unyoke
usance858013usance
valance1269253valance
vandyke1842513vandyke
vane75534693_van_e
wacke145918623_wacke
wake114935703_wa_ke
wane76344723_wan_e
wank115632513_wank_
wanked144517153_wanked
wanker134219973_wanker
wanks126124483_wanks
wannabe1234533wannabe
yank115423673_yank_
yanked144312243_yanked
yanks125316573_yanks
zanana153810363zanan_a
zananas16319563zananas

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.376475242.0
2DLD Change Limit1127163855.18621734.7
3Display Results3853850.1263055.6
 (SQL Overall)1786913855.68831415.4
 
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.