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

146 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
cubicle133700(None) 
cubicles1435881cubicles
cubicly1644991cubicly
cuticle1138231cuticle
auricle9139812auricle
calicle113111432calicle
caulicle1245042caulicle
chicle134312542c_hicle
cubic114313422cubic__
cubical1338462cubical
cubics123810162cubic_s
cubicula1444072cubicula
curricle12145932curricle
cuticles1237892cuticles
funicle12237482funicle
jubile152910262jubi_le
nubile83212712nubi_le
tunicle9308032tunicle
article9310923article
audible10228243audible
audile73315303audi_le
auricled11135703auricled
auricles10138333auricles
babiche1644573babiche
bible95119423__bible
bice86235563__bic_e
bile66147183__bi_le
birle75023633__birle
bubale104014623bub_ale
bubble94016593bub_ble
cable95329913cab__le
cabriole1276933cabriole
caliche14329963caliche
calicles123811433calicles
calycle14245833calycle
canticle1239703canticle
cariole9818343cariole
caulicles1344383caulicles
cenacle1139123cenacle
ceviche1744143ceviche
chicles143512503c_hicles
chicly16429203c_hicly
chile105626893c_hi_le
choice132010523choic_e
ciboule1145093ciboule
cicale10314503c__icale
cilice103213353cilic_e
circle1039703c_ircle
clavicle1543603clavicle
cliche133712453c_liche
clubable1436093clubable
cobble123615263cob_ble
coble94823173cob__le
coracle112011723coracle
cornicle1258783cornicle
crucible1445193crucible
cubage1178273cub_age
cube85830213cub___e
cubically1846143cubically
cubicity1746033cubicity
cubiculum1752333cubiculum
cubing114213953cubi_ng
cubism12348703cubi_sm
cubisms13306883cubisms
cubist104214443cubi_st
cubists11359023cubists
cubit94122893cubi__t
cubital1137103cubital
cubiti10399083cubi_ti
cubits103714033cubi_ts
cubitus11346783cubitus
cuddle104414533cu_ddle
cuisse8318333cu_isse
cuittle946403cuittle
culices113713123culices
culicid1247383culicid
culicine1248343culicine
cupule103410723cu_pule
curable112414513curable
curbable1447663curbable
curdle95514313cu_rdle
curiae84518373curi_ae
curial84019153curial_
curie74533043curi__e
curite85222943curi_te
curlicue1243223curlicue
curricles13105423curricles
curule83614123cu_rule
cuticula1244953cuticula
cuticulae1344263cuticulae
cutie76925933cuti__e
cuttle84113893cu_ttle
cycle1239523c__ycle
debacle1237443debacle
funicles13246833funicles
fusible1237023fusible
fusile94313493fusi_le
futile93914953futi_le
guile64521133gu_i_le
habile11515213habi_le
icicle1036583_icicle
jubilee16298293jubilee
jubiles16289373jubi_les
juice14311323ju_ic_e
labile8315223labi_le
mobile103613543mobi_le
muscle10310973mu_scle
musicale1247343musicale
nubble103813713nub_ble
nuncle839363nu_ncle
ossicle944483ossicle
panicle11129983panicle
pedicle1238973pedicle
pubic114513723pubic__
publicly1743313publicly
pumice1238223pumic_e
quibble2034713quibble
quiche2057903qu_iche
radicle103510713radicle
reticle94112623reticle
rubace10310173rubac_e
rubble104315673rub_ble
ruble74521253rub__le
rutile65217683ruti_le
sanicle91210263sanicle
silicle937753silicle
subfile122010503subfile
subniche1554253subniche
subrule939643subrule
subsale9310543subsale
subscale1247603subscale
subtile91912623subtile
subtitle1046603subtitle
subtle82113433sub_tle
tubercle1244413tubercle
tubule839853tub_ule
tuille63012643tu_ille
tunicae9328143tunicae
tunicles10217133tunicles
ubique1784883_ubique
uncle7317053_u_ncle
utile54718933_uti_le
utricle937913utricle
vehicle15175253vehicle
vesicle12217923vesicle
wavicle1534063wavicle

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271466.95319276.1
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.45223978.9
 
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.