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

283 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
cicala1031005(None) 
cicada1136411cicada
cicalas1139301cicalas
cicale10314501cicale
acicula11228132acicula
cabala103516912cabala
cecal94619112cecal_
cicadae1244852cicadae
cicadas1235992cicadas
cicely1338832cicely
citola838392citola
coala77521122c_oala
jicama1734882jicama
pical95524372pical_
picara10311902picara
tical76021492tical_
ticals83214712ticals
aciculae12267703aciculae
acicular12218663acicular
aciculas12228563aciculas
ala312463603___ala
apical10913903apical_
apicals1159923apicals
arcana8912583arcana
argala74712673argala
bacalao1146613bacalao
bacula103112673bacula
becalm1239203becalm
biali73419073bi_ali
bialy105119323bi_aly
bicarb1238543bicarb
binal75323823binal_
cabal95222153cabal_
cabalas113516003cabalas
cabals104020153cabals
cabana103913563cabana
cabbala1367183cabbala
caca85528083__caca
cacao95420003caca_o
cacaos104616183cacaos
cacas95627983caca_s
cackle143416923cackle
caecal103713733caecal_
calf96339563__calf
calk105527663__calk
call66838673__call
calla74827073c_alla
calm85032363__calm
calo64936443__calo
calx135722793__calx
canal75428043canal_
canals84421663canals
canola8313623canola
cantala94114673cantala
canula8312963canula
casa65630863__casa
casaba1079263casaba
casava1157873casava
cascara1138313cascara
catalo8314853catalo
catalpa1136503catalpa
catcall1139153catcall
cavalla1257883cavalla
ceca84820783cec__a
cecally1459393cecally
cedula977643cedula
cella75420313c_ella
cercal10314123cercal_
chacma1537903chacma
chalah143511663c_halah
chalk144814603c_halk
challa114014193challa
chela103916803c_hela
chica125818263chic__a
chicane1489553chicane
chicano1496873chicano
chicas135916473chica_s
chicle134312543chic_le
chicly16429203chic_ly
chimla1337593chimla
chiral114614413chiral_
chital114313883chital_
choana1138443choana
chola104718033c_hola
cholla113911023cholla
ciao64924183ci_a_o
cibol9512023cibol_
cibols1039523cibols
cicero1048503cicero
cichlid1545313cichlid
cigar8911803ciga_r
cigars9910723cigars
cilia73016763ci_lia
cinema1047653cinema
cingula10327173cingula
circa9311403ci_rca
circle1039703circle
circular1247903circular
citable11313463citable
cithara12166513cithara
citolas939363citolas
citole8311503citole
citral81113893citral_
citrals91111673citrals
civil103411933civil_
clinal8311553clinal_
cloaca1037263cloaca
coal66939253c_oal_
coalas87418963c_oalas
coals76129603c_oals
coaly105521593c_oaly
cobalt10317393cobalt
coca88030643coc__a
cocain101315013cocain
cocas95926573coca_s
coccal9310223coccal_
cochlea1435343cochlea
cockle143913573cockle
cocoa98517883coc_oa
coital84117053coital_
cola66541393__cola
comal95125133comal_
comical13312223comical_
conical11316203conical_
copal95621783copal_
copalm125010813copalm
copals105018943copals
copula102812043copula
coral76033453coral_
corals85325143corals
coxal146116673coxal_
craal74117753craal_
craals84113303craals
cubical1338463cubical_
cubicula1444073cubicula
cupola10317693cupola
cupula10328433cupula
curara83712203curara
cuticula1244953cuticula
cycad13507273cyca_d
cycads14476213cycads
cycas126513823cyca_s
cycle1239523cyc_le
cyclo1237703cyc_lo
cynical1437873cynical_
decal85523233decal_
decals93717713decals
dial55935063di_al_
dials64925343di_als
dicamba1453413dicamba
dicast9315573dicast
dicta84915633dic_ta
ducal84816423ducal_
eidola737683eidola
epical10413393epical_
facula112912233facula
fecal105119213fecal_
fecula113310053fecula
fibula11258053fibula
fickle153912973fickle
fickly18318533fickly
fila74729133fi__la
final83922033final_
finale94116763finale
finals94316163finals
fiscal1139333fiscal_
fiscals1238003fiscals
focal104917673focal_
gala55635163__gala
halala94715093halala
hawala12368913hawala
hila76228353hi__la
icicle1036583icic_le
icily101211693_icily
impala10256933impala
jacal14313703jacal_
jacals1539873jacals
jacana1537933jacana
jicamas1845053jicamas
kabala124011553kabala
kamala12339963kamala
kibla1139833ki_bla
kinara10310373kinara
koala95112213_koala
laical8312323laical_
liana53915893li_ana
ligula7359673ligula
local74820273local_
locale83915653locale
locals83714503locals
macula103013673macula
masala8311813masala
mica86428253mic__a
micas96823053mica_s
micell1098193micell
micella11106823micella
mickle143715133mickle
micra96214973mic_ra
miscall1139643miscall
nala46930393__nala
nicad8312613nica_d
nicads938333nicads
nicely1139493nicely
nickle123814483nickle
nicol71113293nicol_
nicols8810243nicols
nidal65217103nidal_
nival84915773nival_
nyala836823_nyala
ocicat101412813ocica_t
ocicats11137413ocicats
oscula837293oscula
pial65636703pi_al_
pibal95217323pibal_
pibals103813083pibals
pica85831493pic__a
picaras11311283picaras
picaro10311323picaro
picas94626523pica_s
piccata1345703piccata
pickle144215653pickle
picul95015363picul_
piculs103511753piculs
pinata83817223pinata
pipal95118353pipal_
pipals104213643pipals
pirana8713263pirana
piraya1167713piraya
pitaya1186603pitaya
plical10411683plical_
qabala17399193qabala
recall83815723recall
rial45938093ri_al_
rials55026673ri_als
riata54618023ri_ata
ribald9209293ribald
richly1438003richly
rictal83113183rictal_
rival85216503rival_
rivals94213183rivals
riyal84413433riyal_
riyals94111083riyals
scalar83612433_scalar
scald84818123_scald
scale74629143_scale
scall74420373_scall
scalp95217983_scalp
scaly104718723_scaly
scilla8310943sci_lla
sial45938833si_al_
sials54227243si_als
sickle124418323sickle
sickly153110483sickly
sifaka1353553sifaka
sigla64515203si_gla
sisal54217733sisal_
sisals63013573sisals
spicula11259293spicula
tala45938053__tala
tiara5315913ti_ara
tickle124616743tickle
tidal64516443tidal_
tincal83913363tincal_
tincals93610643tincals
vial76731093vi_al_
vials85822383vi_als
vicar10513863vica_r
vicarly1536463vicarly
vicars11712263vicars
vicuna11115903vicuna
villa85321233vi_lla
vinal85725813vinal_
vinals94716483vinals
vincula1246393vincula
viola85915543vi_ola
viral86419593viral_
vital84819673vital_
vitals94514303vitals
vizsla1833703vizsla
vocal104715643vocal_
vocals113811583vocals
wicca1247253wic_ca
zocalo1735803zocalo

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 Filter1786911127160.373479064.3
2DLD Change Limit1127162837.19015676.8
3Display Results2832830.0933043.0
 (SQL Overall)1786912837.65623340.0
 
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.