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

154 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
funicles1324683(None) 
funicle12237481funicle_
tunicles10217131tunicles
auricles10138332auricles
cubicles1435882cubicles
cuticles1237892cuticles
fungibles1542812fungibles
funiculus1443472funiculus
nuncles939842nun_cles
panicles121010112panicles
sanicles10149942sanicles
tunicle9308032tunicle_
uncles8317162_un_cles
articles10310243articles
audibles11215533audibles
audiles83112613audi_les
auricle9139813auricle_
auricled11135703auricled
bernicles1345403bernicles
binocles1236413binocles
bunches144116033bun_ches
bundles103515773bun_dles
bungles104116763bun_gles
calicles123811433calicles
canticles1339183canticles
caulicles1344383caulicles
cenacles1238023cenacles
chicles143512503_chicles
cornicles1368243cornicles
cubicle1337003cubicle_
culices113713123culic_es
curricles13105423curricles
cuticle1138233cuticle_
denticles1237753denticles
dunces95215753dun_c_es
dunches133312583dun_ches
dunites8313593duni_tes
enisles72312603_enisles
failles102914133f_ailles
fancies124018783fan_cies
fanciless1444603fanciless
fascicles1664263fascicles
fenagles12186083fenagles
fences114617113fen_c_es
fencibles1644093fencibles
fetiales11319613fetiales
fetiches1636953fetiches
fices106031163f__ic_es
fiches145219533f__iches
ficoes114613463f__icoes
files85441273f__i_les
filles94224523f__illes
finagles12237553finagles
finales104016013fin_ales
finches153914193fin_ches
finialed1255503finialed
finials103210153finial_s
finises10312903fini_ses
finishes1438983finishes
finites10315923fini_tes
flinches16358953flinches
foibles1238853f_oibles
follicles1444103follicles
fondles113512613fon_dles
fornices1369103fornic_es
fuddles123611933fu_ddles
fugles104715783fu__gles
fumbles143514413fu_mbles
fungals11276783fungal_s
fungible1444173fungible_
fungicides1752453fungicides
fungoes11388813fun_goes
funguses1254713funguses
funicular14114753funicular
funiculars15143263funiculars
funiculi1343243funiculi
funneled1254873funneled
funnels10348173funnel_s
funnies104113603fun_nies
funplex1932833fun_plex
furies95126373furi__es
furnaces1336053furnac_es
furnishes1536233furnishes
furuncles1442493furuncles
fusible1237023fusible_
fusile94313493fusi_le_
fusillis1143563fusillis
fusils93912343fusi_l_s
futile93914953futi_le_
fuzils18407963fuzi_l_s
guiles73919283gu_i_les
gunites8313123guni_tes
gunwales1244733gunwales
hunches153913463hun_ches
icicles1135943_icicles
jubiles16289373jubi_les
juices1549423ju_ic_es
juncoes16338073jun_coes
jungles154112543jun_gles
lunacies1038013lunacies
lunches124115443lun_ches
lunies64723013luni__es
lunules738953lun_ules
manacles1239523manacles
manilles102312603manilles
maniples12269423maniples
monocles12310673monocles
munches144215793mun_ches
murices112612283muric_es
muscles11310563mu_scles
musicales1346703musicales
musicless1343603musicless
niches114419143__niches
nickles133713823__nickles
nuncle839363nun_cle_
ossicles1054183ossicles
ounces83617773oun_c_es
panicle11129983panicle_
panicled13106783panicled
pedicles1338683pedicles
pinocles1248693pinocles
pumices1338273pumic_es
punches144816133pun_ches
pungles104013713pun_gles
punishes1338113punishes
quaiches2235343quaiches
quiches2139333qu_iches
quinces183210433quinc_es
radicles11249703radicles
reticles103912483reticles
rundles83214713run_dles
runkles114111943run_kles
rutiles74315843ruti_les
sanicle91210263sanicle_
seniles72618023seni_les
silicles1037073silicles
subniches1665153subniches
tuilles72411923tu_illes
tunicae9328143tunicae_
tunicates11268743tunicates
tunics83811263tunic__s
unbales92914863_unbales
uncle7317053_un_cle_
unicycles16143263_unicycles
unifies102714713_unifies
uniques1667443_uniques
unites65024853_uni_tes
unities72520153_unities
unpiles92112783_unpiles
utricles1037223utricles
vehicles16204683vehicles
vernicles1446133vernicles
vesicles13127073vesicles
wavicles1633783wavicles

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621547.26620115.9
3Display Results1541540.0931655.9
 (SQL Overall)1786911547.78222962.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.