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

237 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
funkia133634(None) 
funkias1435381funkias
flunkie1434512flunkie
fundi96814912fundi_
fundic12389082fundic
fungi95014132fungi_
fungic12387812fungic
funk115825622funk__
funked144214112funked
funker133915762funker
funkier14349982funkier
funkily1736512funkily
funking154013022funking
funks125318912funk_s
funky154315132funk_y
hunkie133812382hunkie
junkie17339602junkie
punka114515482punk_a
punkie123513612punkie
punkin123611522punkin
uncia75015162_uncia
amnia75918643amn_ia
anuria6313123anuria
auntie64317703auntie
bankit123617043bankit
banksia1335943banksia
buckra1436753buckra
bumkin14308083bumkin
buna64730723bun__a
bunk105731353bunk__
bunked135118373bunked
bunker124519373bunker
bunking144016193bunking
bunko115514513bunk_o
bunkos124210323bunkos
bunks115125083bunk_s
bunkum1435983bunkum
bunya103810093bun_ya
burka114617693burk_a
buskin123811493buskin
buzukia2242223buzukia
cumbia12379893cumbia
curia74523773cu_ria
duckie133511663duckie
dulia61014983du_lia
dumka12438833dumk_a
dunk96228573dunk__
dunked124315283dunked
dunker113616463dunker
dunking133813263dunking
dunks105621193dunk_s
dunlin739723dunlin
entia5318203_entia
facia103218463f_acia
fakir125111493f_akir
fanega1055783fanega
fanfic1436313fanfic
fanga96119623fan_ga
fascia1148703fascia
fauna84816513faun__a
feria85922713f_eria
finca104714503fin_ca
finial92814183fin_ial
finikin14266863finikin
finis86824263fin_is
fink117532123fink__
finked144214623finked
finking154016603finking
finks125424223fink_s
firkin1337823firkin
flunk125014383flunk__
flunked15398413flunked
flunker14389363flunker
flunkey17405793flunkey
flunkies1536393flunkies
flunking16317773flunking
flunks13469863flunk_s
flunky16408093flunk_y
folia83618933f_olia
folkie13369613folkie
fontina1038633fontina
fuchsia15123573fuchsia
fuci95720313fu_ci_
fuck134924633fuck__
fucked164114483fucked
fucker153414423fucker
fucking173212283fucking
fucks144419253fuck_s
fuckup1733963fuckup
fucoid1237893fucoid
fugio9310923fu_gio
fuji144112003fu_ji_
fujis15379243fu_jis
fulcra1135213fulcra
fulfil1246423fulfil
fulgid1137043fulgid
fun66841143fun___
fund85624983fun__d
funded114413893funded
funder104016083funder
funding124113663funding
funds94119253fun_ds
fundus10429173fundus
funeral1037623funeral
funest94316863funest
funfair1342033funfair
fungal10388733fungal
fungo94413133fun_go
fungoid1245253fungoid
fungus10418183fungus
funkers143712063funkers
funkiest152810973funkiest
funned103613953funned
funnel93610743funnel
funner93414103funner
funnier103210173funnier
funnies104113603funnies
funnily1336373funnily
funning113813613funning
funny114614833fun_ny
funs75235733fun__s
fusain958643fusain
fusaria1046223fusaria
fusil84715323fu_sil
fustian1036903fustian
fustic11910633fustic
fusuma1134503fusuma
fuzil173810703fu_zil
gonia64117533gon_ia
gunk95423573gunk__
gunkier12369553gunkier
gunks104517723gunk_s
gunky135514113gunk_y
hankie133915713hankie
honkie133011673honkie
hunk116029543hunk__
hunker133917673hunker
hunkey164210883hunkey
hunkier144512143hunkier
hunkies143214503hunkies
hunks125321453hunk_s
hunky155417733hunk_y
inia45024703_in_ia
junk155121033junk__
junked184311693junked
junker174213653junker
junket173815023junket
junkier18339493junkier
junkies183711693junkies
junking193910073junking
junkman2043173junkman
junks164815973junk_s
junky194513233junk_y
junta123713673jun_ta
kuna85120703kun__a
luckie123611413luckie
luna46229853lun__a
lungi65516053lungi_
lungis77113023lungis
lunk86030723lunk__
lunker104718343lunker
lunks94822453lunk_s
lunula636173lunula
mania75634153man_ia
muni65824413mun_i_
munis75022003mun_is
muntin82915183muntin
muskie123412543muskie
muskit122813253muskit
nankin1039673nankin
nubia7311233nu_bia
nuncio837973nuncio
nutria639913nutria
opuntia9134153opuntia
pennia84412973pennia
pinkie124414273pinkie
pucka133412803puck_a
pukka10457133pu_kka
puna65331653pun__a
pundit92914183pundit
punji1438203punji_
punjis1536693punjis
punk105729973punk__
punkah15347093punkah
punkas123410673punkas
punker123718823punker
punkey154011173punkey
punkier133512793punkier
punkies134216803punkies
punkins133111113punkins
punkish16257693punkish
punks114822683punk_s
punky144419393punk_y
qualia1559563qualia
quokka1841893quokka
runic73615773run_ic
runkle103611543runkle
spunkie13215303spunkie
sundial859863sundial
sunk85031813sunk__
sunken103511783sunken
sunket103721363sunket
sunlit61516103sunlit
sunna55016063sun_na
tanka93817483tank_a
tenia55324483ten_ia
tuna45127843tun__a
tundra736423tundra
tunic74018223tun_ic
tunica8379813tunica
unai44824783_unai_
unais53420773_unais
unakin10310963_unakin
unbid83214643_unbid
unci65019463_unci_
unciae83215313_unciae
uncial83715223_uncial
undid72415363_undid
unfit84518563_unfit
unfix15429033_unfix
unhip10178823_unhip
unit45140073_un_it
unkind113310573_unkind
unkink9308713_unkink
unknit1068593_unknit
unlit55025463_unlit
unmix14388973_unmix
unpin72613243_unpin
unrig61711413_unrig
unrip72012863_unrip
untie54425493_untie
until53517743_until
unwit84417523_unwit
unzip16207623_unzip
urbia7311143_urbia
xenia124814773xen_ia
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.373479064.3
2DLD Change Limit1127162374.65624208.8
3Display Results2372370.0763118.4
 (SQL Overall)1786912375.10535003.1
 
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.