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

138 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
canticle123970(None) 
canticles1339181canticles
anticly12410052_anticly
article9310922_article
calicle113111432ca_licle
canaille1048412canaille
cantic103920532cantic__
cantle84522152cant__le
caulicle1245042caulicle
centile94217182centi_le
cuticle1138232c_uticle
denticle1137772denticle
panicle11129982pan_icle
pantile93918482panti_le
particle1239532particle
sanicle91210262san_icle
anile54634463_an_i_le
antiacne1048583_antiacne
antic75728863_antic__
anticar9312663_anticar
antick124814583_antic_k
anticked1538393_anticked
anticks134612253_anticks
anticline11410703_anticline
anticold1147473_anticold
antics84621453_antic_s
anticult10411683_anticult
antiflu1046683_antiflu
antimale10312463_antimale
antipole10910153_antipole
antique1638883_antique
articled1137063_articled
articles10310243_articles
auricle9139813_auricle
bastile9313913basti_le
bastille1047993bastille
cabriole1276933cabriole
caddice13327733caddic_e
calcicole1244443calcicole
caliche14329953ca_liche
calicles123811423ca_licles
calycle14245833ca_lycle
canailles1148263canailles
cancel105316683can__cel
candidly1545213candidly
candle94321483can__dle
canfield1444333canfield
canine83826703can_i_ne
cannie83819363canni__e
cannily1239263canni_ly
canoodle1144173canoodle
cantabile1346893cantabile
cantal84122033cant_al_
cantala94114673cant_ala
cantals93919573cant_als
canthal12410053canthal_
cantilena1144473canti_lena
cantillate1247343cantillate
cantina93417253canti_na
cantinas102713773cantinas
canting104725903canti_ng
cantles94721413cant__les
caprice1349683capric_e
capriole1276913capriole
captive1438973capti_ve
cariole9818343ca_riole
carriole1089863carriole
cartable121314093cartable
caruncle1244713caruncle
castable121613973castable
castle84918963cast__le
cattie85221013catti__e
cattily123210853catti_ly
cattle85118903ca_t_tle
caulicles1344383caulicles
cenacle1139123cen_acle
centiare1067203centiare
centiles103615813centi_les
centime114513033centi_me
centriole1145673centriole
centuple12164043centuple
chantable1636893chantable
chanticleer1851203chanticleer
chicle134312543c__hicle
clavicle1543603clavicle
continue10311123continue
cornicle1258783cornicle
cubicle1337003c_ubicle
curricle12145933curricle
cuticles1237893c_uticles
denticles1237753denticles
entice81316863_entic_e
entitle7610293_entitle
fascicle1554633fascicle
franticly1744013franticly
funicle12237483fun_icle
gentile83515293genti_le
hantle94318203hant__le
intitle7610583_intitle
kantele1138253kant_ele
lattice938433lattic_e
lenticel1066123lenticel
lenticule1144273lenticule
manacle11310283man_acle
manciple1445093manciple
mandible1337543mandible
manille92613273man_ille
maniple11249653man_iple
mantic104120903mantic__
manticore1346073manticore
mantilla1048163mantilla
mantle84420923mant__le
mastiche1547173mastiche
monticule1344713monticule
nontitle846923nontitle
panicled13106783pan_icled
panicles121010103pan_icles
pantie84326473panti__e
pantiled113111593panti_led
pantiles103617153panti_les
pantofle1364553pantofle
partible1238063partible
particles1339803particles
pastiche1546933pastiche
pastille1038943pastille
pentacle1239383pentacle
quantile1747323quanti_le
radicle103510713ra_dicle
reticle94112623_reticle
sanicles10149943san_icles
scantily1337583scanti_ly
tactile9310613tacti_le
tangible1145603tangible
tentacle1037693tentacle
testicle1037443testicle
tunicle9308033tun_icle
ventricle1444383ventricle
wavicle1534063wa_vicle

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.233766914.2
2DLD Change Limit1461621388.50317189.5
3Display Results1381380.0602300.0
 (SQL Overall)1786911388.79620315.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.