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

219 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
arriba86768(None) 
arroba898661arroba
agria65517142agri_a
amrita8411132amrita
araroba945762araroba
aria46245422a_ri_a
arnica8310442arnica
arris56824682arri_s
arrival1037562arrival
arrive91311792arrive
arrobas969212arrobas
atria56022342atri_a
zariba1736982zariba
aba512850953a___ba
abba810522653a__bba
abri65522213abri__
abris75722603abri_s
acrid86920103acri_d
acrobat11411813acrobat
adrift10313113adrift
aecia73819283aeci_a
aerial64625713aerial
aerie54634603aeri_e
aeried74221863aeried
aerier64823153aerier
aeries64737783aeries
aerify122810113aerify
aerily93017013aerily
aerobat9514473aerobat
aerobe8412403aerobe
aerobia939463aerobia
afrit8323173afri_t
afrits9311903afrits
agita6315423a_gita
agrias74315393agrias
airbag956963air_bag
airier64619363airier
airily93014823airily
airing74927503airing
ajiva1586803a_jiva
alba68328333a__lba
alibi7514233a_libi
aliya83713483a_liya
ameba9312383a_meba
amia66836903a_mi_a
amiga85514813a_miga
amnia75918643amni_a
amoeba1035603amoeba
amritas939093amritas
angina7413133angina
anima74620073a_nima
anuria6313123anuri_a
aorist64827873aorist
aorta55922573aor_ta
aporia8315863apori_a
arabic10312733arabic
arabica1147283arabica
ararobas1046183ararobas
arb510448423a_r_b_
arbs66834733a_r_bs
arcana8912583arcana
arcing95819643arcing
ardeb8314523ardeb_
ardebs937013ardebs
area45843393a_r_ea
areca75618633a_reca
areic73219393arei_c
arena55323813a_rena
areola6813673areola
arepa75615563a_repa
argala74712673argala
argil65116883argi_l
argils75213623argils
arias55438023a_rias
arid57642713a_ri_d
ariel55228973a_riel
aril45843023a_ri_l
arils58732203a_rils
arise56436433a_rise
arista6415293arista
armada938783armada
armies85123693armies
armilla936993armilla
arming94719803arming
arnicas939543arnicas
aroid65428343aroi_d
aroids75118223aroids
aroint6328153aroint
aroma71220143a_roma
arrack121110253arrack
arraign845063arraign
arrant6623253arrant
arras55626133arr_as
array86317143arr_ay
arrayal1055843arrayal
arrays95311683arrays
arrear6310253arrear
arrest63722633arrest
arrhizal2042953arrhizal
arrises71617583arrises
arrivals1145933arrivals
arrived11127353arrived
arriver10117793arriver
arrives101311513arrives
arrow83414883arr_ow
arrows92813483arrows
arrowy12288273arrowy
arroyo936963arroyo
arsine64021043arsine
arsino64113513arsino
arsis55722423arsi_s
artier63419733artier
artily92814713artily
artisan759463artisan
artist64125543artist
ascribe1147743ascribe
asrama839193asrama
atrial65418943atrial
atrip75315753atri_p
atrium8411823atrium
aucuba1045493aucuba
aura45836253aur__a
auric74521733auri_c
auris55331533auri_s
aurist65027253aurist
aurora6411763aurora
barrier94017733barrier
barring104021593barring
barrio8312573barri_o
barrios9310773barrios
bribe94820783_bribe
caramba1336893caramba
cardia9916373cardi_a
caribe103416753caribe
carina84325323carina
carried103717153carried
carrier93619583carrier
carries94328013carries
carrion9312673carrion
ceiba938703_ceiba
ceria75125353ceri_a
coria75828323cori_a
corrida1078503corrida
crib86323583_crib_
cribs94516753_cribs
curia74523773curi_a
drib76823263_drib_
dribs85115063_dribs
earring83519013earring
erica7316543_erica
errata639013errata
erring73816483erring
farina94618233farina
farrier103514893farrier
feria85922713feri_a
garring93116713garring
harridan12145123harridan
harried113815533harried
harrier104417753harrier
harries103525493harries
jarina134014063jarina
jarring153613193jarring
kerria10339913kerri_a
larrigan944213larrigan
latria62313593latri_a
lorica8310443lorica
maria75032883mari_a
marimba1354983marimba
marina84623413marina
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
myrica1336833myrica
noria55722183nori_a
oribi7311093_oribi
orra46120723orr__a
orrice81410163orrice
orris54516553orri_s
paprica1337003paprica
paprika1544003paprika
pareira937533pareira
parried103615723parried
parrier93717653parrier
parries93925843parries
parring103222063parring
partita9310863partita
prima95019343_prima
raia46638383_rai_a
raita54623073_raita
rarify123210063rarify
raring74332873raring
rarity93615493rarity
ria36745503__ri_a
rib56848033__rib_
ribs65833023__ribs
rumba93612513_rumba
sarcina9310733sarcina
scribal1137963scribal
scribe104613533scribe
stria55723203stri_a
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarring83318303tarring
tarsia65514273tarsi_a
terbia8311153terbia
tribal8611133_tribal
tribe74420273_tribe
troika1035493troika
urbia7311143urbi_a
varia85824203vari_a
warrigal1244313warrigal
warring113717973warring
warrior1045363warrior
yerba101010763yer_ba
zareba1736423zareba
zareeba1842423zareeba
zaribas1836043zaribas

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.1401276364.3
2DLD Change Limit1127162195.90619085.0
3Display Results2192190.0762881.6
 (SQL Overall)1786912196.12229188.3
 
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.