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

199 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
funkias143538(None) 
funkia1336341funkia_
flunkies1536392flunkies
funkers143712062funkers
funkier14349982funkier
funkiest152810972funkiest
funkily1736512funkily
funking154013022funking
funks125318912funk__s
funnies104113602funnies
hunkies143214502hunkies
junkies183711692junkies
punkas123410672punk_as
punkies134216802punkies
punkins133111112punkins
anurias7312253anurias
aunties73920073aunties
bankits133410153bankits
banksias1445893banksias
buckras1537343buckras
bumkins15318013bumkins
bunas75126573bun__as
bunkers133715953bunkers
bunking144016193bunking
bunkos124210323bunk_os
bunks115125083bunk__s
bunkums1544053bunkums
bunnies94415003bunnies
bunyas11359433bun_yas
burkas124513803burk_as
buskins133310943buskins
cumbias13338963cumbias
dinkies123716033dinkies
duckies143613813duckies
dulias71212743du_lias
dunkers123512193dunkers
dunking133813263dunking
dunks105621193dunk__s
dunlins849553dunlins
facias113415803f_acias
fakirs13468083f_akirs
fancies124018783fancies
fanegas1145713fanegas
fanfics1535173fanfics
fangas105017193fan_gas
fannies103415643fannies
fascias1258413fascias
faunas94013633faun__as
ferias95020393f_erias
fincas113512073fin_cas
finial92814183fin_ial
finials103210153fin_ials
finis86824263fin_i_s
finking154016603finking
finks125424223fink__s
firkins1437663firkins
flunkers15347533flunkers
flunkeys18263173flunkeys
flunkie1434513flunki_e
flunking16317773flunking
flunks13469863flunk__s
folkies143612253folkies
fontinas1136853fontinas
fuchsias16113533fuchsias
fuckers163611593fuckers
fucking173212283fucking
fucks144419253fuck__s
fuckups1832923fuckups
fucoids1335663fucoids
fuddies123211203fuddies
fugios1037583fu_gios
fujis15379243fu_ji_s
fulfils1345723fulfils
funders113813933funders
fundi96814913fundi__
fundic12389083fundi_c
funding124113663funding
funds94119253fun__ds
fundus10429173fun_dus
funeral1037623funeral
funerals1146453funerals
funfair1342033funfair
funfairs1442133funfairs
fungal10388733fun_gal
fungals11276783fungals
fungi95014133fungi__
fungic12387813fungi_c
fungoes11388813fungoes
fungoids1343993fungoids
fungous11367433fungous
fungus10418183fun_gus
funk115825623funk___
funked144214113funk_ed
funker133915763funk_er
funkiness16226873funkiness
funky154315133funk__y
funnels10348173funnels
funnier103210173funnier
funniest113010733funniest
funnily1336373funnily
funning113813613funning
funs75235733fun___s
furies95126373fu_ries
fusains1038363fusains
fusils93912343fu_sils
fustian1036903fustian
fustians1146403fustians
fustics1279593fustics
fuzils18407963fu_zils
gunkier12369553gunkier
gunkiest132610573gunkiest
gunks104517723gunk__s
gunnies83413123gunnies
hankies143617763hankies
honkies143015143honkies
hunkers143314333hunkers
hunkeys17386193hunkeys
hunkie133812383hunki_e
hunkier144512143hunkier
hunkiest153812333hunkiest
hunks125321453hunk__s
huskies143212083huskies
junkers184010863junkers
junkets18377623junkets
junkie17339603junki_e
junkier18339493junkier
junkiest192610173junkiest
junking193910073junking
junkman2043173junkman
junks164815973junk__s
juntas134210503jun_tas
luckies133313683luckies
lunas55025013lun__as
lungis77113023lungi_s
lunies64723013lun_ies
lunkers113414603lunkers
lunks94822453lunk__s
manias84029033man_ias
munis75022003mun_i_s
muntins92715133muntins
muskies133614673muskies
muskits13278563muskits
nankins1159053nankins
nubias8310093nu_bias
nuncios937113nuncios
nutrias739813nutrias
opuntias10103233opuntias
outkiss1137783outkiss
pinkies133818263pinkies
punas74826753pun__as
pundits10379293pundits
punjis1536693punji_s
punka114515483punk_a_
punkah15347093punk_ah
punkahs16284783punkahs
punkers133714853punkers
punkeys16366493punkeys
punkie123513613punki_e
punkier133512793punkier
punkiest149312663punkiest
punkin123611523punki_n
punkish16257693punkish
punks114822683punk__s
punties94520783punties
quokkas1942063quokkas
runkles114111943runkles
spunkies14227593spunkies
sulkies114315763sulkies
sundial859863sundial
sundials946753sundials
sunkets113511283sunkets
sunnas63914563sun_nas
tankas104613763tank_as
tenias64720073ten_ias
tunas54224123tun__as
tundras857113tundras
tunics83811263tun_ics
tunnies73614263tunnies
unais53420773_unai_s
uncia75015163_uncia_
unciae83215313_unciae
uncial83715223_uncial
uncials92510523_uncials
undies73821963_undies
unfits93910293_unfits
units54923433_un_its
unkind113310573_unkind
unkink9308713_unkink
unkinks10265413_unkinks
unknits1135553_unknits
unpins82312383_unpins
unrigs7159003_unrigs
unrips8199453_unrips
unties64326923_unties
unwits9389893_unwits
unzips17175273_unzips
urbias839093_urbias
xenias133712973xen_ias
zinnias1635863zinnias

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271996.26621389.6
3Display Results1991990.0762618.4
 (SQL Overall)1786911996.76526414.0
 
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.