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

230 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
arnicas93954(None) 
arnica8310441arnica_
alnicos985532alnicos
animas84418722a_nimas
arabicas1247192arabicas
arecas84817442ar_ecas
arias55438022ar_i_as
armonicas13106122armonicas
ericas8315462er_icas
abacas104414723a_bacas
acacias11510393acacias
acronical1347833acronical
addicts1176013addicts
advices13136933advices
agitas7310593a_gitas
agnizes17328843agnizes
agrias74315393agri_as
ajivas1655133a_jivas
alias55834603a_li_as
aliyas93911803a_liyas
alnico877943alnic_o
alpacas1137073alpacas
amanitas1048523amanitas
amias75831463a_mi_as
amices105018013a_mices
amicus10389993a_micus
amigas95912163a_migas
amnia75918633amni_a_
amnic95516233amnic__
amnions93710913amnions
amnios84912513amni_os
amritas939093amritas
anabas8314083a_nabas
anas46649863a_n__as
angas65827983a_n_gas
anginas8310953anginas
anils56326723a_ni_ls
anima74620073a_nima_
animal85016253a_nimal
animals94111703a_nimals
animes84719593a_nimes
animis84615943a_nimis
animus84211613a_nimus
anions64123033a_nions
anis45746463a_ni__s
anises64826693a_nises
anlas55626933a_n_las
annas55824883a_n_nas
annonas738793annonas
anoas57226493a_n_oas
antas55432033a_n_tas
anticar9312663anticar
anticks134612253anticks
antics84621453antic_s
apical10913903a_pical
apicals1159923a_picals
apices104916263a_pices
apneas83211383apn_eas
apnoeas946353apnoeas
arabica1147283arabica_
arcs67834783ar__c_s
arctics1138953arctic_s
arcus76918863ar__cus
areas55935773ar__eas
areca75618633ar_eca_
areic73219393areic__
arenas65021993ar_enas
arenites8917103arenites
areolas71013863areolas
arepas85515703ar_epas
argalas84011083argalas
argils75213623argi_ls
arginase946433arginase
aria46245423ar_i_a_
ariels65119373ar_iels
arils58732203ar_i_ls
arises65233803ar_ises
aristas7413523aristas
armadas1038173armadas
armies85123693armi_es
armillas1046663armillas
armings103811493armings
armonica1276863armonica_
aroids75118223aroi_ds
aroints7313133aroints
aromas81018613ar_omas
arracks1387733arracks
arras55626133ar__ras
arriba867673arriba_
arris56824683arri__s
arrises71617583arrises
arrival1037563arrival
arrivals1145933arrivals
arrives101311513arrives
arrobas969213arrobas
arsenical1145573arsenical
arsenicals1252973arsenicals
arsenics1056763arsenic_s
arsines73518813arsines
arsis55722423arsi__s
article9310923article
articles10310243articles
artisan759463artisan
artisans888523artisans
artists74215583artists
asdics9439863asdic_s
aspics104211563aspic_s
atonias73315993atoni_as
atonics93613713atonic_s
attics84413283attic_s
awnings11406713awnings
barbican1445343barbican
barbicans1544483barbicans
barcas101016603bar__cas
bonitas939453bonitas
bricks144614623br_icks
cardiacs1376903cardiacs
cardias10715093cardi_as
carices114220953car_ices
carinas93622383car_inas
cariocas1239663cariocas
caritas93316943car_itas
carnies94123963carni_es
carnival1345613carnival
carnivals1444483carnivals
chicas135916463_chicas
conical11316203conical
conics103920593conic_s
cornices12713283cornices
cricks144316053cr_icks
cynical1437873cynical
cynics13377363cynic_s
darics94314113dar_ic_s
darnings10378553darnings
dornicks1544403dornicks
earnings9419323earnings
erica7316543er_ica_
farcical1546953farcical
farinas103215233far_inas
farinhas14325363farinhas
fincas113512073fin_cas
finical1239693finical
formicas1545993formicas
fornical1347793fornical
fornices1369103fornices
fracas11311993fr_acas
gallicas1136933gallicas
garlics1038013garlic_s
granitas92610223granitas
gringas938033gringas
harmonicas17104773harmonicas
hernias10310773herni_as
ionics84214473ionic_s
irenical1048553irenical
irenics937833irenic_s
ironical1049963ironical
japonicas20113253japonicas
jarinas143712183jar_inas
maniacs114313063maniacs
manias84029033mani_as
manics103919933manic_s
manilas93915873manilas
maniocas12298463maniocas
maracas11313773mar_acas
marascas1247383marascas
marinas93519373mar_inas
micas96823053__micas
minicab13177163minicab
minicabs14135063minicabs
minicam131110053minicam
minicams14126863minicams
minicar11109313minicar
minicars12118503minicars
myricas1436743myricas
nicad8312613__nicad
nicads938333__nicads
nicks114920493__nicks
nipas77116673__nipas
orcas75918623or__cas
ornis54616773orni__s
orrices9129363orrices
panics103815363panic_s
papricas1447053papricas
pareiras1038183pareiras
partitas10310253partitas
picas94626523__picas
prices104524543pr_ices
pricks144414263pr_icks
primas104418103pr_imas
princes113015143princes
radical103312793radical
radicals112610153radicals
radices102314263radices
raias54631123_rai_as
raitas64417673_raitas
rances84625443ran_ces
ranids75118703rani_ds
ranis55235833rani__s
ranulas7311773ranulas
rias45540593_r_i_as
rices75536153_r_ices
ricks115126133_r_icks
sarcinas1039273sarcinas
senecas939013senecas
silicas9310603silicas
snicks124312473_snicks
sonics84315633sonic_s
spicas104715823_spicas
taenias7311283taeni_as
tarsias74013373tarsi_as
tenias64720073teni_as
tonics83617863tonic_s
triacs83913223tr_iacs
trices84826333tr_ices
tricks125319013tr_icks
troikas1135023troikas
tunica8379813tunica_
tunicae9328143tunicae
tunics83811263tunic_s
uranias72113813urani_as
urbias839083urbi_as
varias95019903var_i_as
varices123313573var_ices
varnas94212823varn__as
veronicas1446393veronicas
vincas113912453vin_cas
warnings12358453warnings
wricks154610623wr_icks
xenias133712973xeni_as
zaribas1836043zar_ibas

Search took 10 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.296603685.8
2DLD Change Limit1340272308.64315507.0
3Display Results2302300.0932473.1
 (SQL Overall)1786912309.03219784.2
 
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.