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

482 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
nannie6371322(None) 
cannie83819361cannie
nannies73015201nannies
bonnie85314852bonnie
canine83826702canine
cannier94014162cannier
carnie84421092carnie
fannies103415642fannies
grannie8310352grannie
hankie133915712hankie
mannite9312902mannite
nance74721842na_nce
nancies93516842nancies
nandin7313032nandin
nankin1039672nankin
nanny84813812nann_y
nappie104112262nappie
narine63422552narine
ninnies73713612ninnies
panne76623652pann_e
pannier93613352pannier
pantie84326472pantie
tannic82811472tannic
tannin62613922tannin
acne66625873_acn_e
aerie54634603_aerie
aggie73415013_aggie
agnize16329563_agnize
alanine7316863alanine
aline57243153_aline
alkie95520033_alkie
amie66339843_a_mie
amine75835373_amine
amnia75918633_amnia
amnic95516233_amnic
amnio75218043_amnio
ananke1038283ananke
ane37866943_a_n_e
anele55628833_anele
angle64528873_angle
ani37751173_a_ni_
anil46437433_a_nil
anile54634463_anile
anime75423203_anime
anis45746463_a_nis
anise55129703_anise
ankle95220253_ankle
anna45529013_ann_a
annal56520763_annal
annas55824883_annas
annex12310883_annex
annexe1337813annexe
annoy869713_annoy
annul55813383_annul
anode65021033_anode
anole55330373_anole
anomie83215963anomie
ansae55720973_ansae
antae56828293_antae
ante46538903_a_nte
anti45536363_anti_
antic75728863_antic
antis55033313_antis
antre55224523_antre
anvil82712603_anvil
auntie64317703auntie
azine146721413_azine
baddie104114033baddie
baggie102912193baggie
bagnio937523bagnio
bailie83818363bailie
bandied114414303bandied
bandies104124863bandies
bandit93821133bandit
bane65250423ba_n_e
bangle94018953bangle
bani65334953ba_ni_
baning95127833baning
bankit123617043bankit
banned94721343banned
banner84421503banner
bannet84925333bannet
banning103818233banning
banns75321233bann_s
banshie12129543banshie
banties94324763banties
barbie105018353barbie
barmie103816393barmie
barnier93213673barnier
bawtie113812143bawtie
beanie83618593beanie
benne76521123benn_e
benni74715363benni_
bennies93917313bennies
bennis84314803bennis
bonne75124713bonn_e
bonnier94711313bonnier
brannier10218933brannier
bunnies94415003bunnies
burnie83715413burnie
byrnie11348573byrnie
cabbie122913343cabbie
caddie104316443caddie
cammie124615293cammie
canape10913513canape
candid104517853candid
candied113816023candied
candies104125613candies
candle94321483candle
cane66653113ca_n_e
cangue91012443cangue
canid85526343ca_nid
canines93724033canines
caning94128623caning
canna75919333cann_a
cannas84518403cannas
canned95022063canned
cannel84216403cannel
canner84625983canner
canniest10313363canniest
cannily1239263cannily
canning103620133canning
cannon84514443cannon
cannot83616773cannot
canny105817693cann_y
canoe75627253ca_noe
canonic11312933canonic
canonise10511093canonise
canonize1959833canonize
cantic103920533cantic
cantle84522153cantle
carnies94123963carnies
catnip1097963catnip
cattie85221013cattie
cavie104621593ca_vie
conine84528553conine
connive1238993connive
crannied1137893crannied
crannies10313013crannies
cyanine122911513cyanine
dance85223133da_nce
dandier93714573dandier
dandies94121443dandies
dandle84218093dandle
dangle84119303dangle
danio6319783da_nio
darkie113714013darkie
dassie74615573dassie
dautie72914693dautie
dawtie103011093dawtie
donne65520463donn_e
donnee74317063donnee
donsie7613643donsie
dunnite857333dunnite
enamine91214293enamine
faerie93514683faerie
falsie93513853falsie
famine114318193famine
fancied133310603fancied
fancier123412063fancier
fancies124018783fancies
fane75343563fa_n_e
fanfic1436313fanfic
fanlike142610503fanlike
fanned104117473fanned
fanner94218183fanner
fanning113615073fanning
fanny114816043fann_y
fanwise1336633fanwise
fanzine1937123fanzine
farcie114816473farcie
faunae95210373faunae
fawnier13296363fawnier
fennier10339253fennier
finnier10319943finnier
funnier103210163funnier
funnies104113603funnies
gahnite1135973gahnite
gamine94620153gamine
gane55145293ga_n_e
gangue81310573gangue
gannet74321853gannet
ganoid8314433ganoid
garni6315703garni_
gawsie1038463gawsie
genie66124923_genie
ginnier8298973ginnier
goonie73615563goonie
grannies9312613grannies
guanine8810543guanine
gunnies83413123gunnies
hackie154615623hackie
hance105424153ha_nce
handier113817443handier
handle104219293handle
hankies143617763hankies
hanse85722793ha_nse
hantle94318203hantle
hawkie163810093hawkie
heinie92512663heinie
hinnied11348103hinnied
hinnies103615103hinnies
honkie133011663honkie
hunkie133812383hunkie
inane52820343ina_n_e
indie63721463_indie
jane115031473ja_n_e
jangle144416293jangle
jaunce15367433jaunce
jennies143511623jennies
jinnee13411573jinnee
jinni125310633jinni_
jinnis13489053jinnis
johnnie1772283johnnie
junkie17339603junkie
kainit10414483kainit
kainite1149543kainite
kane85133963ka_n_e
kanji1647453kanji_
kanjis1735963kanjis
kaonic1238763kaonic
laddie83713173laddie
lambie103213663lambie
lanai5319573lanai_
lanais6316793lanais
lanate6421263lanate
lance75126723la_nce
lane45153323la_n_e
langue71012173langue
lankier113711633lankier
lanner64920593lanner
lanose6313593lanose
larine63927043larine
lassie64917743lassie
launce8469183launce
lawine93316463lawine
loonie64216453loonie
magpie1139093magpie
maline84529083maline
mamie95826003ma_mie
mammie94313783mammie
manage93818903manage
manche133515103manche
mane65052013ma_n_e
manege94113203manege
mange84930183ma_nge
mangier104114063mangier
mangle93921323mangle
mania75634143ma_nia
manic94629433ma_nic
manlier92414023manlier
manlike133012783manlike
manna75522533mann_a
mannan85413623mannan
mannas85019803mannas
manned94418643manned
manner84020513manner
manning103616383manning
mannish121710693mannish
mannites10312613mannites
mannose939243mannose
manque17259513manque
manse75528223ma_nse
mantic104120903mantic
mantid93820373mantid
mantis83926033mantis
mantle84420923mantle
manure8313653manure
manwise1239183manwise
marine84230403marine
mashie11315933mashie
mavie104722563ma_vie
meanie83718393meanie
meinie82614523meinie
minnies93617363minnies
monie75631653_monie
naan47621933naan__
naans55815253naan_s
nabe66029493na__be
nabis76020573na_bis
nacre75715363na_cre
nadir61012973na_dir
nae35952743na___e
naevi867873naevi_
naggier9309153naggier
naif76839013na__if
nail45838653na__il
naive85116213na_ive
name65637413na__me
naming93917893naming
nan37854873na_n__
nana46632893na_n_a
nanas55928633na_nas
nances83618643nances
nancy105214923na_ncy
nandina838913nandina
nandins8312003nandins
nanism8311203nanism
nankeen1135043nankeen
nankins1159053nankins
nannyish1443303nannyish
nans46139393na_n_s
naoi46024633na_oi_
nape65230803na__pe
napkin1236903napkin
nappe96114993na_ppe
nappier114411173nappier
nappies114613393nappies
nardine82712573nardine
nargile847653nargile
naric76824173na_ric
naris55735293na_ris
nastic82915963nastic
nastier74115293nastier
nasties73520493nasties
native9613013native
nattier73614623nattier
nature6311263nature
navaid1037643navaid
nave75732313na__ve
navies95218623na_vies
navvies1335323navvies
nazi136219873na_zi_
nazis145216083na_zis
neatnik1143333neatnik
nellie63614813nellie
nene45932063n_en_e
newbie11135413newbie
newie81813483n_ewie
newsie9138213newsie
nine45842173n_in_e
ninny84514933ninn_y
nixie125114943n_ixie
nonage7313683nonage
nonce75719823n_once
none45743173n_on_e
nonlife1038553nonlife
nonuse63212253nonuse
noogie73612313noogie
nookie103712433nookie
nuance859043nuance
nudie65118673n_udie
nudnik1153313nudnik
nuncio837963nuncio
nuncle839363nuncle
nunlike11258073nunlike
nunnish1035933nunnish
pandied113913443pandied
pandies104224503pandies
pandit93820753pandit
pane64950283pa_n_e
panic93923903pa_nic
panier84425503pa_nier
panini8314273panini
panino8315683panino
panned94123433panned
panner84224763panner
pannes85522853pannes
panniers10488853panniers
panning104019393panning
panpipe1034833panpipe
pansies94521983pansies
panties94230933panties
pantile93918483pantile
pardie96021443pardie
pastie85525523pastie
patine85328123patine
pattie84020963pattie
pawnee113115403pawnee
paynim1337363paynim
pennae84314033pennae
penne75423853penn_e
penni74617903penni_
pennia84412973pennia
pennies94218813pennies
pennine93712953pennine
pennis84315743pennis
pinkie124414273pinkie
pinnae84414643pinnae
pinnies93318443pinnies
punkie123513613punkie
punnier93511263punnier
rainier71614253rainier
ramie75027823ra_mie
rance75028513ra_nce
rancid9513863rancid
randier83618473randier
randies84225663randies
ranee55438103ra_nee
range64728413ra_nge
rangier83714353rangier
rani46640103ra_ni_
ranid66429333ra_nid
ranis55235833ra_nis
rankle103414883rankle
ranpike1335933ranpike
rapine85023083rapine
ratine65131823ratine
ravine95522223ravine
rennin63914033rennin
runnier74010113runnier
sabine84020383sabine
saline65132703saline
saltie63422423saltie
sandier84017843sandier
sane45954333sa_n_e
sanies63031953sa_nies
saning75127643saning
sannop837373sannop
sannup836563sannup
sansei63411903sansei
santir6315243santir
savine94220283savine
sennit63117923sennit
shannies113411253shannies
sonnies7315223sonnies
sonsie6614853sonsie
stanine73417073stanine
stannic936663stannic
stannite847583stannite
sunnier73412153sunnier
taenia6313193taenia
taeniae739083taeniae
talkie103914443talkie
tammie104212683tammie
tangier83013903tangier
tangle74019953tangle
tannage8209583tannage
tannate71813523tannate
tanned75219953tanned
tanner63722283tanner
tanning83618253tanning
tannins72813223tannins
tannish101610573tannish
tannoy958353tannoy
tansies74521243tansies
tassie66017023tassie
tattie64817513tattie
tawie84819813ta_wie
tawnier10318463tawnier
tawnies102812503tawnies
tawpie11339143tawpie
tennies73017973tennies
tennis64015303tennis
tentie62521183tentie
tinnier72910133tinnier
tonne54921433tonn_e
toonie63617993toonie
townie93312303townie
trannies8415013trannies
tunnies73614263tunnies
uncannier1144033uncannier
untie54425493_untie
vahine123612113vahine
valine94623093valine
vane75534683va_n_e
vanned104614483vanned
vanner94215843vanner
vanning113912463vanning
vauntie1036633vauntie
vawntie1343943vawntie
venine93718433venine
waddie114013323waddie
waffie15338563waffie
wahine123813013wahine
wallie93216803wallie
wandle105316663wandle
wane76344713wa_n_e
wangle103817503wangle
wanier93920683wa_nier
waning103623803waning
wannabe1234533wannabe
wanned104318013wanned
wanner94019623wanner
wanning113816213wanning
weenie92612023weenie
wennier10318603wennier
wienie9229973wienie
yabbie13308653yabbie
zanier154314713za_nier
zanies153219673za_nies
zinnia1536013zinnia

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.186960704.3
2DLD Change Limit1127164825.12621989.1
3Display Results4824820.1403442.9
 (SQL Overall)1786914825.45232775.3
 
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.