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

246 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
canular931032(None) 
cannular1046281cannular
canula8312961canula_
canulae9311181canulae
canulas9312851canulas
ranular739431ranular
alular6311352_alular
angular838532_angular
annular737692annular
candler103516592candler
canicular1346462canicular
cannula937432cannula_
cannulae1046492cannulae
cannulas1037582cannulas
canola8313622canola_
canolas9313992canolas
canulate10314552canulate
capsular1245402capsular
cingular11256972cingular
consular1038812consular
copular113810602copular
cupular11317622cupular
fabular12288692fabular
facular122810442facular
granular946892granular
hamular1236972hamular
lunular736012lunular
macular113011942macular
pabular11259472pabular
papular11299762papular
planular1044752planular
radular837832radular
ranula6311812ranula_
ranulas7311772ranulas
scapular1245372scapular
tabular9279762tabular
venular1037682venular
zonular1656492zonular
acicular12218663acicular
alar46340073_a__lar
alula5317093_alula_
alulae6312743_alulae
anear55420323_an_ear
angler74017863_angler
anlas55626933_an_las
anovular1144163_anovular
antiar6317173_antiar
antler64615553_antler
anural65714743_anural
anuran64313243_anuran
ashlar9338193_ashlar
aurar54420253_a_urar
bacula103112673bacula_
basilar937303basilar
cabala103516913cabala_
cabalas113516003cabalas
cabler104519173ca_bler
cackler153812573cackler
caesar8410933ca_esar
cajoler16398393cajoler
calamar1149293calamar
calcar10312753ca_lcar
calla74827073ca_lla_
callan83619603ca_llan
callas84526753ca_llas
caller85125483ca_ller
calycular1643483calycular
canal75428043can__al
canaled103615563canaled
canaller1038953canaller
canals84421673canal_s
canard9314763can__ard
canary11314693can__ary
cancan10314103can_can
canceler12238913canceler
cancer104220923can_cer
cancha134411613cancha_
canchas143212403canchas
candela1089743candela_
candelas1139533candelas
candle94321483candl_e
candled113815743candled
candlers114214103candlers
candles104422343candles
candor94516423can_dor
candour104210243candour
canella9310793canella
canellas10310563canellas
caner75334773can__er
caneware1347803caneware
canful11610263canful__
canfuls1248423canful_s
canker124422523can_ker
canna75919333can_na_
cannas84518403can_nas
canner84625983can_ner
cannier94014163cannier
cannulate1148633cannulate
canoer85121073can_oer
cantal84122033can_tal
cantala94114673cantala
cantalas104013523cantalas
cantals93919573cantals
canter85230113can_ter
canthal12410053canthal
cantle84522153cantl_e
cantles94721413cantles
cantor85621523can_tor
cantrap113310283cantrap
canulated12310673canulated
canulates11312873canulates
canvas113813333can_vas
capelan1139003capelan
capitular1343773capitular
caroler93816753caroler
cartulary1444643cartulary
casual81112863casu_al
casuals91410533casuals
catclaw1443973catclaw
caudad10157673ca_udad
caudal91611483ca_udal
caul65630003ca_ul__
cauld85318443ca_ul_d
caulds95512383ca_ulds
caules85927253ca_ules
caulis85320083ca_ulis
caulk115315453ca_ul_k
caulker13456893ca_ulker
caulks125611863ca_ulks
cauls75727773ca_ul_s
causal81413203ca_usal
causer84117783ca_user
caviar11310163ca_viar
caviler1249063caviler
cedula977643cedula_
cedulas1058503cedulas
cellar84514983c_ellar
cellular1045163cellular
chandler14358373chandler
chukar1534633c_hukar
cingula10327173cingula_
circular1247903circular
coagula1045413coagula_
collar83816173c_ollar
condylar1443653condylar
copula102812043copula_
copulae112810613copulae
copulas113811563copulas
coruler9311713coruler
cougar958783c_ougar
cupula10328433cupula_
cupulae11347853cupulae
dandler94414273dandler
dangler96912813dangler
facula112912233facula_
faculae123210353faculae
fibular12267973fibular
frenular1144633frenular
gangliar1064123gangliar
glandular1142783glandular
gular6314833__gular
handcar1337373handcar
handler113516163handler
hangar104114513han_gar
hanuman1237133hanuman
hauler95015123ha_uler
insular7138703insular
jaguar1435283jagu_ar
jangler153811833jangler
jocular1637303jocular
jugular1534513jugular
kantar10311153kan_tar
lacunar9136293lacunar
landler84113203landler
ligular8348533ligular
lingular9407503lingular
lobular936663lobular
locular938953locular
lunula636173lunula_
lunulae735613lunulae
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443ma__lar
mangler103215643mangler
manila84518303manila_
manilas93915873manilas
manipular1344223manipular
manual8313463manu_al
manuals9311223manuals
manuary1237773manu_ary
manurer938583manurer
mauler84416713ma_uler
modular1087363modular
morular978223morular
mutular936643mutular
nebular956483nebular
nodular876703nodular
ocular8610133_ocular
oracular1047533oracular
oscular937933oscular
ovular946833_ovular
papula103011113papula_
papulae11249353papulae
pendular1144943pendular
piacular1246573piacular
pilular938203pilular
pinnular1044433pinnular
planula935773planula_
planulae1044793planulae
popular11319563popular
radula749313radula_
radulae837963radulae
radulas839583radulas
regular838423regular
saccular1246893saccular
sandbar10108193sandbar
sangar73617683san_gar
sansar63613393san_sar
scalar83612433sca__lar
scapula1136343scapula_
scapulae1255433scapulae
scapulars1343873scapulars
scapulary1643203scapulary
scapulas1246133scapulas
secular92211533secular
simular938673simular
singular9327563singular
spatular1044653spatular
talar56225383ta__lar
tangler83515073tangler
tegular836603tegular
titular737523titular
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungular836773ungular
uvular955563_uvular
vacuolar1353483vacuolar
valvular1443463valvular
vascular1346293vascular
vocabular1652163vocabular
wangler113312653wangler
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

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.406440125.6
2DLD Change Limit1340272467.06318975.9
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.56223630.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.