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

224 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
yuccas1342655(None) 
yucas106013911yu_cas
yucca12467441yucca_
buccal1248242buccal
meccas1239492meccas
succah1336642succah
succahs1435322succahs
wiccas1336542wiccas
yecchs16414952yecchs
yuca95716722yu_ca_
yucch15417432yucc_h
yucks144717192yu_cks
yugas95012062yu_gas
abacas104414723abacas
arecas84817443arecas
aucubas1145173aucubas
auras55932553au_ras
bacca111012183bacca_
baccae12119703baccae
barcas101016603barcas
bocces123912023bocces
boccias13307193boccias
boccis123911133boccis
bubbas94110703bubbas
buckos143710893buckos
buckras1537343buckras
bucks134824293bu_cks
bunas75126573bu_nas
buncos104011593buncos
bunyas11359433bunyas
buras74736293bu_ras
burkas124513803burkas
burqas174410903burqas
bursas85318273bursas
cacas95627983_cacas
chicas135916463chicas
cocas95926573_cocas
coccal9310223coccal
coccus979283coccus
cocoas104915743cocoas
cuppas12458593cuppas
cuscus1038113cuscus
cutlas8313093cutlas
cycas126513823_cycas
dachas124113253dachas
ducal84816423du_cal
ducat86225903du_cat
ducats95011763ducats
duces86327473du_ces
ducks124823213du_cks
ductal938993ductal
ducts85319893du_cts
dulias71212743dulias
dumas85420433du_mas
dunces95215753dunces
duras65727723du_ras
durras74713373durras
ericas8315463ericas
euclase938933euclase
facias113415803facias
feluccas1542213feluccas
fincas113512073fincas
fracas11311993fracas
fucks144419253fu_cks
fucous11399863fucous
fucus105515893fu_cus
guacos94410313guacos
guavas1037153guavas
gucks123917303gu_cks
gummas114810513gummas
hubcap1553993hubcap
hubcaps1643543hubcaps
hucks144322173hu_cks
hulas84920883hu_las
huzzas1735863huzzas
jubas144614223ju_bas
jucos144111713ju_cos
judas134911883ju_das
juices1549423juices
juncos15449233juncos
juntas134210503juntas
kurtas10349883kurtas
luces75528433lu_ces
lucks115723563lu_cks
lucres84513303lucres
luffas12337483luffas
lumas75622913lu_mas
lunas55025013lu_nas
lycras11287243lycras
mecca1139933mecca_
micas96823053_micas
mochas13310653mochas
muches134718993muches
mucins102712513mucins
mucks134622643mu_cks
mucors104410843mucors
mucosa10166273mucosa
mucosas11146673mucosas
mucous104411653mucous
mucus94015743mu_cus
mudcap1335133mudcap
mudcaps1444103mudcaps
mudcat11311203mudcat
mudcats1236223mudcats
mudras94212253mudras
mulcts10298713mulcts
mullas84215933mullas
muras75329563mu_ras
murras84916003murras
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
muscats1138933muscats
myricas1436743myricas
nachas114914193nachas
nubias8310083nubias
nucha10229793nucha_
nuchae11218513nuchae
nuchal11218873nuchal
nuchals12216933nuchals
nutcase975763nutcase
ocas66729633__ocas
orcas75918623_orcas
ouches114322183ouches
ounces83617773ounces
outcast91013743outcast
outgas7313203outgas
pacas96029403_pacas
pachas135017143pachas
picas94626523_picas
puces94924633pu_ces
pucka133412803pucka_
pucks134322103pu_cks
pujas145513323pu_jas
pumas95121563pu_mas
punas74826753pu_nas
punkas123410673punkas
pupas95219283pu_pas
purdas92612263purdas
pyurias1236703pyurias
quacks214710103quacks
quicks21389303quicks
quotas15339433quotas
recces10614913recces
ruanas6311263ruanas
ruches114819583ruches
rucks114422053ru_cks
ruckus12407793ruckus
rumbas102512013rumbas
scubas103710223scubas
seccos1039923seccos
siccan1037593siccan
socas74026183_socas
spicas104715823spicas
stuccos1153933stuccos
subas74724073su_bas
success1146403success
succor1036623succor
succors1137413succors
succubas1443853succubas
succuss1134993succuss
sucks114523073su_cks
sucrase9310343sucrase
sucres84218893sucres
sulcal8311273sulcal
sulcus8410493sulcus
sulfas9311563sulfas
sumacs105512103sumacs
summas104313163summas
sunnas63914563sunnas
suras55336323su_ras
surras65919533surras
sutras64818583sutras
suttas63813793suttas
tubas75119573tu_bas
tucks114721123tu_cks
tufas85314383tu_fas
tunas54224123tu_nas
ulnas55716533_ulnas
ulvas84511503_ulvas
uncap9312283_uncap
uncaps1039813_uncaps
uncase83817433_uncase
uncast84215713_uncast
uncos74117033_uncos
uncus74014983_uncus
upas68322383_u_pas
upcast102710093_upcast
ureas55826013_ureas
utas45924953_u_tas
uveas84912283_uveas
vincas113912453vincas
vulvas12388843vulvas
wicca1247253wicca_
wiccan1335033wiccan
wiccans1434603wiccans
yachts1437023yachts
yacks144419813y_acks
yautias1046333yautias
yclad11246383y_clad
yeas78638423y__eas
yecch15558093yecc_h
yechs136112583y_echs
yentas94614213yentas
yerbas11119293yerbas
yocks144418373y_ocks
yogas96615603y_ogas
yoicks15375933yoicks
yuan76120013yu__an
yuans84613323yu_ans
yuch125818533yu_c_h
yuck136423533yu_c_k
yucked164013563yucked
yucky175411693yu_cky
yuga85615423yu_ga_
yuks116418023yu__ks
yulan8411493yu_lan
yulans958673yulans
yules84521583yu_les
yupons11398353yupons
yups96121603yu__ps
yurta86014253yurta_
yurts87216533yu_rts
yutzes18408413yutzes

Search took 6 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.1401276364.3
2DLD Change Limit1127162245.21621609.7
3Display Results2242240.0802800.0
 (SQL Overall)1786912245.43632871.8
 
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.