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

172 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
cupolas1127775(None) 
cupola10317691cupola_
canolas9313992canolas
cholas114818002c_holas
citolas939362citolas
colas75436772c__olas
copulas113811562copulas
crapolas1247402crapolas
cupels10310202cupel_s
cupolaed1342752cupolaed
cuppas12458592cup_pas
cupula10328432cupula_
cupulae11347852cupulae
cupular11317622cupular
cupules113210262cupules
cutlas8313102cu_tlas
rugolas836372rugolas
acerolas1048053acerolas
areolas71013863areolas
arugolas944403arugolas
aureolas846853aureolas
auroras7311703auroras
bipolar1145453bipolar
bolas74733763__bolas
cabalas113516003cabalas
caeomas1138403caeomas
cajoles163712103cajoles
callas84526753c_allas
canola8313623canola_
canulas9312853canulas
capelan1139003capelan
capelans1238013capelans
capias10318353cap_ias
capons104119503capo_ns
caporal11410943caporal
caporals1238923caporals
capos94826073capo__s
capotes11314643capotes
carols85124983carol_s
carolus94612603carolus
cedulas1058503cedulas
challas124414123challas
chelas113817203c_helas
chimlas1437453chimlas
chola104718033c_hola_
chollas123811353chollas
cholos114716853c_holos
chromas142512693chromas
chuppas1644123chup_pas
cibols1039523cibol_s
cicalas1139303cicalas
cipolin1148783cipolin
cipolins1238033cipolins
citola838393citola_
citoles9312553citoles
coalas87418963c_oalas
coals76129603c__oals
cocas95926573c__ocas
cocoas104915743coco_as
codas84724243c__odas
cola66541393c__ola_
colds85726973c__olds
coles76055063c__oles
cols66553083c__ol_s
colts76633293c__olts
colzas174010513c__olzas
comas95833003c__omas
cools75632633c_ool_s
copalms13367543copalms
copals105018943copal_s
coplots11511593coplots
copouts11311083copouts
coppras13327833coppras
copras103517153cop_ras
copula102812043copula_
copulae112810613copulae
copular113810603copular
corollas1039213corollas
coronas93916913coronas
couples115317053coup_les
coupons112710563coupo_ns
crapola1136913crapola_
creoles9913323creoles
cuboids1236723cuboids
cuckolds1743003cuckolds
cuddles114014093cuddles
cuestas957933cuestas
cullay113910173cu_llay
cullays12347703cu_llays
cullis84115993cu_llis
culls75425813cu__lls
culms95314193cu__lms
cults75022553cu__lts
cumbias13338963cumbias
cumulus1135453cumulus
cupel9514303cupel__
cupeled1257793cupeled
cupeler1177483cupeler
cupelers1266733cupelers
cupfuls1444343cupfuls
cupids11369193cup_ids
cupolaing1443403cupolaing
cuppa11398523cup_pa_
cuppers133712213cuppers
cuprous1149743cuprous
cuprums1334453cuprums
cups85430823cup___s
cupulate122810033cupulate
cupule103410723cupul_e
curaras93911953curaras
curdles103814573curdles
curls74927103cu_rl_s
curtals93111623curtals
cutlass938013cu_tlass
cutoffs1533603cutoffs
cutouts938033cutouts
cuttles93613923cuttles
cymols1377193cymol_s
dipolar1056853dipolar
dipoles101013753dipoles
eupneas935233eupneas
eupnoeas1042803eupnoeas
hooplas1239203hooplas
hulas84920883hu__las
hulloas103911913hulloas
impalas11236953impalas
judokas1992453judokas
jupons15377803jupo_ns
kolas94822233__kolas
lipomas1156443lipomas
lupous849433lupo_us
molas75132093__molas
moolas83615593_moolas
mucosas11146683mucosas
mullas84215933mu_llas
outpolls1046213outpolls
payolas12148973payolas
plugolas1143133plugolas
polar75623453__polar
polars84419353__polars
poles75351003__poles
polis74731163__polis
polkas1239103__polkas
polls74627723__polls
polos76129913__polos
pols66044563__pol_s
polys105718763__polys
pupas95219283pup__as
pupilar11125313pupilar
pupils10389913pupil_s
pyrolas1239863pyrolas
quolls15327303qu_olls
quotas15339433qu_otas
repolls939053repolls
rubeolas10154853rubeolas
rugola736293rugola_
rugosas844973rugosas
sapotas939613sapotas
scapulas1246133scapulas
scopulas1265483scopulas
subpolar1245183subpolar
supples11511283supples
tolas54532773__tolas
tupelos936113tupelos
upas68322383_up__as
upfolds13133753_upfolds
upholds13135243_upholds
upload9257783_upload
uploads10266503_uploads
uvulas946523_uvulas
violas93713523_violas
yupons11398353yupo_ns

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271725.92322628.2
3Display Results1721720.0463739.1
 (SQL Overall)1786911726.37528030.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.