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

151 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
funicle1223748(None) 
funicles13246831funicles
tunicle9308031tunicle
auricle9139812auricle
cubicle1337002cubicle
cuticle1138232cuticle
fungible1444172fungible
funiculi1343242funiculi
fusible1237022fusible
fusile94313492fusi_le
futile93914952futi_le
nuncle839362nun_cle
panicle11129982panicle
sanicle91210262sanicle
tunicae9328142tunicae
tunicles10217132tunicles
uncle7317052_un_cle
anile54634463_ani_le
article9310923article
audible10228243audible
audile73315303audi_le
auricled11135703auricled
auricles10138333auricles
bernicle1245443bernicle
binocle1136493binocle
bundle94315573bun_dle
bungle97116113bun_gle
calicle113111433calicle
canticle1239703canticle
caulicle1245043caulicle
cenacle1139123cenacle
chicle134312543_chicle
cornicle1258783cornicle
cubicles1435883cubicles
cubicly1644993cubicly
curricle12145933curricle
cuticles1237893cuticles
denticle1137773denticle
dunce86319263dun_c_e
dunite7315013duni_te
enisle63412093_enisle
facile112514883faci_le
faille93414743f_aille
fancily1538253fancily
fascicle1554633fascicle
fenagle11197153fenagle
fence105319913fen_c_e
fencible1545603fencible
fice95737113f__ic_e
fiche134616743f__iche
fickle153912973f__ickle
file75446643f__i_le
fille84327403f__ille
finable122213623finable
finagle11238313finagle
finale94116763fin_ale
finial92814183finial_
finialed1255503finialed
finials103210153finials
finical1239693finical
finicky1943713finicky
finite9316823fini_te
foible11410383f_oible
follicle1344393follicle
fondle104412943fon_dle
fuddle113312103fu_ddle
fugle94915543fu__gle
fumble133214263fu_mble
fundic12389083fundic__
fungal10388733fungal_
fungals11276783fungals
fungibles1542813fungibles
fungic12387813fungic__
fungicide1642553fungicide
funicular14114753funicular
funiculus1443473funiculus
funkily1736513funkily
funnel93610743funnel_
funneled1254873funneled
funnels10348173funnels
funnily1336373funnily
funplex1932833fun_plex
furnace1235943furnac_e
furuncle1342153furuncle
fusibly1535863fusibly
fusil84715323fusi_l_
fusilli1044233fusilli
fusils93912343fusi_ls
fuzil173810703fuzi_l_
fuzils18407963fuzi_ls
guile64521133gu_i_le
gunite7414403guni_te
gunwale1134733gunwale
icicle1036583_icicle
jubile152910263jubi_le
juice14311323ju_ic_e
jungle144012653jun_gle
lunule638433lun_ule
manacle11310283manacle
manille92613273manille
maniple11249653maniple
monocle1139663monocle
muscle10310973mu_scle
musicale1247343musicale
nice65534713__nic_e
niche105016793__niche
nickle123814483__nickle
nubile83212713nubi_le
nuncles939843nun_cles
ossicle944483ossicle
ounce77019933oun_c_e
panicled13106783panicled
panicles121010113panicles
pedicle1238973pedicle
penile82219603peni_le
pinocle1138143pinocle
pumice1238223pumic_e
pungle94413573pun_gle
punily11311773puni_ly
quiche2057903qu_iche
quince173910133quinc_e
radicle103510713radicle
reticle94112623reticle
rundle73214233run_dle
runic73615773runic__
runkle103611543run_kle
rutile65217683ruti_le
sanicles10149943sanicles
senile63420213seni_le
silicle937753silicle
subniche1554253subniche
tuille63012643tu_ille
tunable92511313tunable
tunic74018223tunic__
tunica8379813tunic_a
tunicate103310043tunicate
tunics83811263tunic_s
unable83819223_unable
unbale83616403_unbale
unciae83215313_unciae
uncles8317163_un_cles
unicycle15153183_unicycle
unique1558163_unique
unite54828383_uni_te
unpile81914323_unpile
utile54718933_uti_le
utricle937913utricle
vehicle15175253vehicle
vernicle1346433vernicle
vesicle12217923vesicle
wavicle1534063wavicle

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.390458182.1
2DLD Change Limit1340271515.65623696.4
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.09229332.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.