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

440 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
faunae9521037(None) 
fauna84816511fauna_
faunal94711591faunal
faunas94013631faunas
aurae54128112_aurae
faciae112913412faciae
faculae123210352faculae
faena85014202faena_
faenas94412762faenas
fane75343572fa_n_e
faucal11339962faucal
faun76226622faun__
fauns84516752faun_s
fauve114712072fau_ve
infaunae1143772infaunae
jaunce15367432jaunce
lacunae9116802lacunae
launce8469182launce
laurae64011662laurae
sauna54117552sauna_
saunaed836702saunaed
saunas63915432saunas
acne66625873_acn_e
adnate72913483_adnate
agnate73314883_agnate
alae45643753_a_lae
alane56135613_alane
algae65319623_algae
alulae6312743alulae
alumnae955403alumnae
ana39559833_a_na_
anal48037523_a_nal
anas46649863_a_nas
ane37866953_a_n_e
anna45529013_anna_
annal56520763_annal
annas55824883_annas
ansae55720973_ansae
antae56828293_antae
ante46538903_a_nte
apnea73413413_apnea
aquae142212713_aquae
areae55229743_areae
aubade939223_aubade
audad71511393_audad
aunt46553653_aun_t
auntie64317703_auntie
aunts55227633_aunts
aunty85919813_aunty
aura45836253_aura_
aural54428963_aural
aurar54420253_aurar
auras55932553_auras
aurate64426473_aurate
avifaunae1551223avifaunae
baccae12119703baccae
banal75925993ba_nal
bane65250433ba_n_e
baubee103215993baubee
bauble103813213bauble
blunge94311483blunge
bounce104014833bounce
buna64730723_buna_
bunas75126573_bunas
canal75428043ca_nal
canape10913513ca_nape
cane66653123ca_n_e
canna75919333canna_
cannas84518403cannas
cannie83819363cannie
canoe75627253ca_noe
canulae9311183canulae
carinae94318583carinae
carnage10311743carnage
carnal83919203carnal
carnie84421093carnie
catenae9311373catenae
catnap1098383catnap
caudad10157673caudad
caudal91611483caudal
caudate10311353caudate
caudle93912913caudle
causal81413203causal
cause75225353cau_se
dance85223133da_nce
daube85015303dau_be
daunder9348893daunder
daunt65929083daun_t
daunted93810193daunted
daunter83811753daunter
daunts75014083daunts
dautie72914703dautie
dunam8313733_dunam
dunce86319263_dunce
dune56137583_dun_e
epifaunae1481533epifaunae
fable105824753fa_ble
fabular12288693fabular
fabulate1339203fabulate
facade1238803facade
face96140123fa__ce
facete115014833facete
facia103218463facia_
facial113615633facial
facias113415803facias
facile112514883facile
facula112912233facula_
facular122810443facular
fade85736343fa__de
fadge104816993fa_dge
faecal11359813faecal
faerie93514683faerie
faience1237513faience
faille93414743faille
fain75840563fain__
fainer94717243fainer
faint85837063fain_t
fainted114211723fainted
fainter103611053fainter
faints94818783faints
fake115534943fa__ke
falcate12311613falcate
fallal93612693fallal
false84818123fa_lse
falsie93513853falsie
fame95639393fa__me
famine114318193famine
fan67158863fa_n__
fancy134615483fa_ncy
fanes84639893fa_nes
fanfare1336673fanfare
fang85432553fa_n_g
fanga96119623fa_nga
fangas105017193fangas
fanged114318223fa_nged
fangs96224073fa_ngs
fanjet16311393fa_njet
fanned104117473fanned
fanner94218183fanner
fannies103415643fannies
fanny114816043fa_nny
fano75831693fa_n_o
fanon84619013fa_non
fanos85926503fa_nos
fans76247373fa_n_s
fanum10313443fa_num
fanums1137263fanums
farad95720673fa_rad
farce104925323fa_rce
farcie114816473farcie
fare76354463fa__re
farfal123410183farfal
farina94618233farina_
farinas103215233farinas
farle86929243fa_rle
fasciae1247523fasciae
fatal84819373fa_tal
fate75444283fa__te
fatwa1168063fatwa_
fatwas1249053fatwas
faucals12326563faucals
fauces114916153fauces
faucet115816553faucet
faucial1257323faucial
faugh125712963fau_gh
fauld95214493fau_ld
faulds10438963faulds
fault85428313fau_lt
faulted11227723faulted
faults94513553faults
faulty12429363faulty
faunally1445433faunally
faunlike1534763faunlike
fauves125610423fauves
faux146519073fau__x
fava106820263fa_va_
favas115618593fa_vas
fave105532963fa__ve
fawn105321953fawn__
fawned134910423fawned
fawner125910463fawner
fawnier13296363fawnier
fawns115914263fawn_s
fawny144711713fawn_y
faze165630043fa__ze
feculae12339203feculae
fence105319913f_ence
feriae95618603feriae
ferulae10309603ferulae
feuar8310243feu_ar
feudal1037683feudal
fiance11310743fiance
fibulae12237013fibulae
final83922033f_inal
finale94116763f_inale
fine75147953f_in_e
flange103411973flange
flaunt9712913flaun_t
flaunted1234603flaunted
flaunter1135013flaunter
flaunts1056133flaunts
flaunty1354413flaunty
flauta937823flauta_
flautas1036153flautas
flense938903flense
florae94713883florae
flounce1235413flounce
flue75329853flu__e
fluke125016893flu_ke
flume106021173flu_me
flung95114583flun_g
flunk125014383flun_k
flunked15398413flunked
flunker14389363flunker
flunkey17405793flunkey
flunkie1434513flunkie
flunks13469863flunks
flunky16408093flunky
flute86823753flu_te
fossae95510373fossae
found94917843foun_d
founded124011423founded
founder114312573founder
founds104814193founds
fount84727033foun_t
founts94313383founts
foveae1237563foveae
frae75330473f__rae
fraena938063fraena_
frena85915273frena_
fringe104013953fringe
frounce1236153frounce
frugal1036393frugal
fubar1039923f_ubar
fudge105315523f_udge
fugal95613033f_ugal
fugle94915543f_ugle
fugue94313373f_ugue
fume96727633f_u_me
fun66841143f_un__
fund85624983f_un_d
funded114413893f_unded
funder104016083f_under
fundi96814913f_undi
funds94119253f_unds
fungal10388733f_ungal
fungi95014133f_ungi
fungo94413133f_ungo
funk115825623f_un_k
funked144214113f_unked
funker133915763f_unker
funks125318913f_unks
funky154315133f_unky
funned103613953f_unned
funnel93610743f_unnel
funner93414103f_unner
funny114614833f_unny
funs75235733f_un_s
furan84320013f_uran
furane94015493f_urane
furnace1235943furnace
furze176815813f_urze
fuse76429993f_u_se
fusee86224583f_usee
fuze166422373f_u_ze
fuzee175718883f_uzee
galeae74717453galeae
gane55145303ga_n_e
gauche1238553gauche
gauge76117903gau_ge
gaun56427713gaun__
gaunt65430403gaun_t
gaunter82910713gaunter
gauze155712973gau_ze
grunge8359583grunge
guanase836213guanase
guanay1037913guanay
hance105424153ha_nce
hanse85722793ha_nse
haulage1136913haulage
haunch14377343haunch
haunt85229133haun_t
haunted11399733haunted
haunter103111153haunter
haunts95614393haunts
haute89521613hau_te
infauna1044403infauna_
infaunal1143823infaunal
infaunas1143873infaunas
jane115031483ja_n_e
jaunced17335473jaunced
jaunces16307423jaunces
jaunt125025273jaun_t
jaunted15418563jaunted
jaunts137511883jaunts
jaunty16388513jaunty
jounce153310733jounce
kahuna1394103kahuna_
kahunas1473953kahunas
kana85928533ka_na_
kanas95326913ka_nas
kane85133973ka_n_e
kuna85120703_kuna_
kune85424573_kun_e
lacuna8118123lacuna_
lacunal9136553lacunal
lacunar9136293lacunar
lacunas9138173lacunas
lacunate10128963lacunate
lacune8169673lacun_e
laguna7127223laguna_
lagunas8156823lagunas
lagune7158633lagun_e
lamiae84817453lamiae
laminae93512973laminae
lanai5319573la_nai
lanate6421263la_nate
lance75126723la_nce
lane45153333la_n_e
larvae938843larvae
lauan55216793lau_an
lauans65113533lauans
launces9329003launces
launch11368063launch
launder8309143launder
laura54116203laura_
lauras63414333lauras
lounge75211213lounge
luna46229853_luna_
lunar57017313_lunar
lunas55025013_lunas
lunate6316043_lunate
lune47140493_lun_e
lunge65323803_lunge
maculae113412863maculae
maenad939413maenad
magnate10512703magnate
mammae94613213mammae
mana65341963ma_na_
manage93818903ma_nage
manas76240433ma_nas
manat76039993ma_nat
mane65052033ma_n_e
mange84930193ma_nge
manna75522543manna_
mannan85413623mannan
mannas85019803mannas
manse75528233ma_nse
manual8313463manual
manure8313653manure
maugre9308973maugre
maun65727213maun__
maund85515453maun_d
maunder10328683maunder
maunds9519653maunds
maundy12506783maundy
mauve104013273mau_ve
minae75627723_minae
nae35952743___nae
nana46632903na_na_
nanas55928633na_nas
nance74721843na_nce
nannie63713223nannie
nausea637313nausea
nounal639813nounal
nuance859043nuance
ounce77019933_ounce
padnag1036073padnag
paleae84820293paleae
pane64950293pa_n_e
panne76623653pa_nne
papulae11249353papulae
parae76335703pa_rae
patinae95414403patinae
paunch13369853paunch
pausal81511963pausal
pause75021833pau_se
pavane114113443pavane
pawnage1335873pawnage
pawnee113115403pawnee
pennae84314033pennae
pinnae84414643pinnae
plunge93811053plunge
pounce105214093pounce
prune75119633prun_e
puna65331653_puna_
punas74826753_punas
pupae96515643_pupae
qanat144426843qa_nat
radulae837963radulae
rance75028513ra_nce
ranee55438103ra_nee
range64728413ra_nge
raphae114311733raphae
raunch11358433raunch
ruana5312423ruana_
ruanas6311263ruanas
rugae65114763_rugae
rune45236293_run_e
salpae84614273salpae
sane45954343sa_n_e
sauce75121653sau_ce
saunter72913453saunter
sausage847193sausage
saute55028083sau_te
sundae7312873_sundae
taeniae739083taeniae
tannage8209583tannage
tannate71813523tannate
tarnal63716503tarnal
taunt55532283taun_t
taunted84310963taunted
taunter73111453taunter
taunts65715663taunts
taupe7314163tau_pe
tubae74716643_tubae
tuna45127843_tuna_
tunas54224123_tunas
tune45635863_tun_e
ulnae55214573_ulnae
unai44824783__unai
unau43924153__unau
unbe65319273__unbe
unde55825483__unde
usaunce9103383usaunce
uvulae945323uvulae
vaginae11377683vaginae
vane75534693va_n_e
varna84516173varna_
varnas94212823varnas
vaunt85925313vaun_t
vaunted11438863vaunted
vaunter10309603vaunter
vauntie1036633vauntie
vaunts95212623vaunts
vaunty12409063vaunty
venae85920983_venae
wane76344723wa_n_e
wannabe1234533wannabe
zonae145116443_zonae

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164405.97018880.4
3Display Results4404400.1403142.9
 (SQL Overall)1786914406.25028590.6
 
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.