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

216 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
cupola1031769(None) 
cupolas11277751cupolas
cupula10328431cupula
canola8313622canola
chola104718032c_hola
citola838392citola
cola66541392c__ola
copula102812042copula
crapola1136912crapola
cupel9514302cupel_
cupels10310202cupels
cupolaed1342752cupolaed
cuppa11398522cup_pa
cupulae11347852cupulae
cupular11317622cupular
cupule103410722cupule
rugola736292rugola
acerola947823acerola
areola6813673areola
arugola844353arugola
aureola747033aureola
aurora6411763aurora
bipolar1145453bipolar
bola66035563__bola
bulla74620563bu_lla
cabala103516913cabala
caeoma1039033caeoma
cajole154011183cajole
calla74827073c_alla
canolas9313993canolas
canula8312963canula
capelan1139003capelan
capita102913773capita
capo85829213capo__
capon95221873capo_n
capons104119503capons
caporal11410943caporal
capos94826073capo_s
capote10315733capote
carol75128613carol_
caroli85918233caroli
carols85124983carols
cedula977643cedula
cella75420313c_ella
challa114014193challa
chela103916803c_hela
chimla1337593chimla
cholas114818003c_holas
cholla113911023cholla
cholo105217973c_holo
chroma132912473chroma
chuppa1543973chup_pa
cibol9512023cibol_
cibols1039523cibols
cicala10310053cicala
cipolin1148783cipolin
citolas939363citolas
citole8311503citole
coal66939253c__oal
coala77521123c_oala
coca88030643c__oca
cocoa98517883coco_a
coda77029343c__oda
col59360353c__ol_
colas75436773c__olas
cold77338773c__old
cole66956113c__ole
cols66553083c__ols
colt67158243c__olt
coly96940533c__oly
colza165112983c__olza
coma87134853c__oma
cool66940493c_ool_
cools75632633c_ools
cooly105525423c_ooly
copal95621783copal_
copalm125010813copalm
copals105018943copals
coplot10518273coplot
copout10418783copout
coppra12306833coppra
copra98115463cop_ra
copulae112810613copulae
copular113810603copular
copulas113811563copulas
corolla938623corolla
corona83817403corona
corpora1139353corpora
couple104415963coup_le
coupon102810993coupo_n
coupons112710563coupons
coxa136922963c__oxa
crapolas1247403crapolas
creole8913733creole
cuboid1139503cuboid
cuckold1643723cuckold
cuddle104414533cuddle
cuddly13388413cuddly
cuesta838513cuesta
cull65929643cu__ll
cullay113910173cu_llay
culls75425813cu_lls
cully105520463cu_lly
culm85822383cu__lm
culpa93610963cu_lpa
cult66541153cu__lt
cumbia12379893cumbia
cumuli1036273cumuli
cuneal8611513cuneal
cup76738243cup___
cupeled1257793cupeled
cupeler1177483cupeler
cupful1356423cupful
cupfuls1444343cupfuls
cupid103212783cup_id
cupids11369193cupids
cupolaing1443403cupolaing
cuppas12458593cuppas
cupped134413983cupped
cupper124313863cupper
cuppy144710383cup_py
cupric1249123cupric
cuprous1149743cuprous
cuprum1236743cuprum
cups85430823cup__s
cupulate122810033cupulate
cupules113210263cupules
curara83712203curara
curdle95514313curdle
curia74523773cu_ria
curial84019153curial
curiosa9346643curiosa
curl66035053cu_rl_
curls74927103cu_rls
curly105321233cu_rly
curtal83914543curtal
curtly1149283curtly
curule83614123curule
cuspal1037883cuspal_
cutely115312803cutely
cutlas8313103cu_tlas
cutoff1436563cutoff
cutout8315923cutout
cuttle84113893cuttle
cymol1287623cymol_
cymols1377193cymols
cypsela1442443cypsela
dipolar1056853dipolar
dipole91112853dipole
duopoly1343683duopoly
duple85315863dup_le
eidola737683eidola
eupnea835033eupnea
eupnoea943163eupnoea
hoopla1147633hoopla
hula74923753hu__la
hulloa95011183hulloa
impala10256933impala
judoka18102583judoka
jugula1434983jugula
jupon14479193jupo_n
jupons15377803jupons
kola85124963__kola
lipoma1046753lipoma
lunula636173lunula
lupous849433lupous
mola66035633__mola
moola75117033_moola
mucosa10166273mucosa
mulla74317113mu_lla
outpoll946793outpoll
papula103011113papula
payola11208113payola
pepla9312863pep_la
plugola1043013plugola
pol56449383__pol_
polar75623453__polar
pole65951303__pole
polka11310413__polka
poll66332133__poll
polo66236633__polo
pols66044563__pols
poly96235153__poly
pula65129373__pula
pupa85422813pup__a
pupal97616873pupal_
pupil94712983pupil_
pupilar11125313pupilar
pupils10389913pupils
pyrola1139003pyrola
quoll14379493qu_oll
quota145111963qu_ota
repoll8410793repoll
rubeola9115123rubeola
rugolas836373rugolas
rugosa734563rugosa
sapota8310213sapota
scapula1136343scapula
scopula1154993scopula
sola45541863__sola
subpolar1245183subpolar
supple10410203supple
supply1346893supply
supra73614253sup_ra
tola45236333__tola
tufoli933973tufoli
tupelo836483tupelo
upfold12124953_upfold
uphold12126903_uphold
upload9257783_upload
upo58925863_upo__
upon65817583_upo_n
uvula845153_uvula
viola85915543_viola
yupon10469483yupo_n
yupons11398353yupons

Search took 7 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.376475242.0
2DLD Change Limit1127162165.65619928.6
3Display Results2162160.0603600.0
 (SQL Overall)1786912166.09229332.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.