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

140 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
cubicles143588(None) 
cubicle1337001cubicle_
cuticles1237891cuticles
auricles10138332auricles
calicles123811432calicles
caulicles1344382caulicles
chicles143512502c_hicles
cubicly1644992cubicl_y
cubics123810162cubic__s
culices113713122culic_es
curricles13105422curricles
cuticle1138232cuticle_
funicles13246832funicles
jubiles16289372jubi_les
tunicles10217132tunicles
articles10310253articles
audibles11215533audibles
audiles83112613audi_les
auricle9139813auricle_
auricled11135703auricled
babiches1735253babiches
bibles104617643__bibles
bices95029963__bic_es
biles75542143__bi_les
birles84920643__birles
bubales113513343bub_ales
bubbles104315963bub_bles
cables104527553cab__les
cabrioles1376363cabrioles
calices114321693calic_es
caliches153812273caliches
calicle113111433calicle_
calicoes123911603calicoes
calycles15295693calycles
canticles1339183canticles
carices114220953caric_es
carioles10817083carioles
caudices13337343caudic_es
caulicle1245043caulicle_
cenacles1238023cenacles
ceviches1834843ceviches
chicle134312543c_hicle_
chiles115425303c_hi_les
choices142010613choic_es
ciboules1244533ciboules
cilices113814023cilic_es
cimices13279803cimic_es
circles1139903c_ircles
clavicles1643673clavicles
cliches144213743c_liches
cobbles133814823cob_bles
cobles104622883cob__les
codices12512583codic_es
coracles121811163coracles
cornicles1368253cornicles
crucibles1543743crucibles
cubages1237923cub_ages
cubbies133312883cub_bies
cubes95028163cub___es
cubic114313423cubic___
cubical1338463cubic_al
cubically1846143cubically
cubicities1646823cubicities
cubicity1746043cubicity
cubicula1444083cubicula
cubiculum1752333cubiculum
cubisms13306883cubi_sms
cubists11359023cubi_sts
cubits103714033cubi__ts
cubitus11346783cubi_tus
cuddles114014093cu_ddles
cuishes122810823cu_ishes
cuisses9319883cu_isses
cuittles1045903cuittles
culches143710743cu_lches
culicids1345623culicids
culicines1347013culicines
cultches15316533cultches
cupules113210263cu_pules
curacies12311763curacies
curches143512743cu_rches
curdles103814573cu_rdles
curies84934023curi__es
curites93919863curi_tes
curlicues1343343curlicues
curricle12145933curricle_
cutches143216463cu_tches
cuties84927363cuti__es
cutises94414913cuti_ses
cuttles93613923cu_ttles
cycles1339303c__ycles
cylices14359283cylic_es
debacles1335723debacles
funicle12237483funicle_
guiles73919283gu_i_les
ibices10398163_ibic_es
icicles1135943_icicles
jubile152910263jubi_le_
jubilee16298293jubi_lee
jubilees17244423jubilees
juices1549423ju_ic_es
mobiles112813123mobi_les
murices112612283muric_es
muscles11310563mu_scles
musicales1346703musicales
musicless1343603musicless
nubbles113412433nub_bles
nubile83212713nubi_le_
nuncles939843nu_ncles
ossicles1054183ossicles
panicles121010133panicles
pedicles1338683pedicles
pumices1338273pumic_es
quaiches2235343quaiches
quibbles2134223quibbles
quiches2139333qu_iches
radicles11249703radicles
reticles103912483reticles
rubaces1139313rubac_es
rubbles113715113rub_bles
rubies84420343rubi__es
rubles83921703rub__les
rutiles74315843ruti_les
sanicles10149943sanicles
silicles1037073silicles
subfiles131710723subfiles
subniches1665153subniches
subrules1039733subrules
subsales10310133subsales
subscales1347353subscales
subtitles1156853subtitles
tubercles1344163tubercles
tubules9310233tub_ules
tuilles72411923tu_illes
tunicle9308033tunicle_
uncles8317163_u_ncles
utricles1037223utricles
vehicles16204683vehicles
vesicles13127073vesicles
wavicles1633783wavicles

Search took 9 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.436409841.7
2DLD Change Limit1461621407.53319402.9
3Display Results1401400.0632222.2
 (SQL Overall)1786911408.03222247.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.