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

205 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
arroba89866(None) 
araroba945761araroba
arriba867671arriba
arrobas969211arrobas
acrobat11411812acrobat
aerobat9514472aerobat
aerobe8412402aerobe
aerobia939462aerobia
ararobas1046182ararobas
areola6813672areola
aroma71220142a_roma
arrow83414882arro_w
arrows92813482arrows
arrowy12288272arrowy
arroyo936962arroyo
aurora6411762aurora
aba512850953a___ba
abba810522643a__bba
aboma91114603a_boma
abroad9310943abroad
abrosia939273abrosia
acerola947823acerola
acrobats1258343acrobats
acromia1139963acromia
across8312643across
adobe84814703a_dobe
adobo84711593a_dobo
adroit7518783adroit
aero45435343aero__
aerobats1049833aerobats
aerobes9311493aerobes
aerobic11310213aerobic
aerosat7417183aerosat
aftosa996573aftosa
agora6914333a_gora
agria65517143agr_ia
airbag956963air_bag
airboat9512133airboat
alba68328333a__lba
algaroba1142033algaroba
algarroba125943algarroba
allobar946663allobar
aloha8513613a_loha
ameba9312373a_meba
amoeba1035593amoeba
amrita8411123amrita
angora71111573angora
annona648873annona
anoa45634473a_no_a
aorta55922573aor_ta
apnoea867093apnoea
aporia8315863aporia
apron7318833apro_n
aprons8316993aprons
arb510448423a_r_b_
arbor74818113arbo_r
arbors84717873arbors
arbour84211323arbour
arbs66834733a_r_bs
arcana8912583arcana
arco68331543arco__
ardeb8314523ardeb_
ardebs937013ardebs
ardor64617863ardo_r
ardors74416863ardors
ardour74110893ardour
area45843393a_r_ea
areca75618633a_reca
arena55323813a_rena
areolae7811733areolae
areolar779223areolar
areolas71013863areolas
areole61017283areole
arepa75615563a_repa
argala74712663argala
argol65317263argo_l
argols74514613argols
argon65520593argo_n
argons75018203argons
argosy1036423argosy
argot67728643argo_t
argots74116023argots
aria46245423a_r_ia
ariose64818723ariose
ariosi64313033ariosi
arioso64312403arioso
arista6415293arista
arkose104911343arkose
armada938783armada
armor75118053armo_r
armors85017813armors
armory114211473armory
armour84411853armour
arnica8310443arnica
aroid65428333a_roid
aromas81018613a_romas
arose55832083a_rose
arrack121110253arrack
arrant6623253arrant
arras55626133arr_as
array86317143arr_ay
arrayal1055843arrayal
arrays95311683arrays
arrear6310253arrear
arrest63722633arrest
arris56824683arr_is
arrival1037563arrival
arrive91311793arrive
arrogant949153arrogant
arrogate91210323arrogate
arrowed1148103arrowed
arroyos1036533arroyos
arson55118833arso_n
arsons63917213arsons
arugola844353arugola
arvo76023433arvo__
arvos86015663arvo_s
asrama839193asrama
atria56022333atr_ia
aucuba1045493aucuba
aura45836253aur__a
aureola747033aureola
aurorae739663aurorae
auroral7310473auroral
auroras7311703auroras
aurous64119263aurous
barroom1139373barroom
barrow114512763barro_w
barrows123411683barrows
caramba1336893caramba
carbora11310703carbora
carioca1139683carioca
carob95325223carob_
carobs104818103carobs
carroch1437093carroch
carrom10513403carro_m
carroms11512403carroms
carrot8423123carro_t
carrots9714623carrots
carroty1248943carroty
chroma132912473chroma
cordoba1255743cordoba
corona83817403corona
dagoba1074943dagoba
earlobe946543earlobe
enrobe86610793enrobe
errata639013errata
error53712233erro_r
errors63311313errors
farrow12309973farro_w
farrows13259783farrows
garron73113493garro_n
garrons82713463garrons
garrote8510103garrote
harrow122610773harro_w
harrows132611033harrows
jerboa1535633jerboa
jojoba1441553jojoba
karroo10410013karro_o
karroos1139313karroos
krona93611793_krona
madrona10288703madrona
marimba1354983marimba
marron83717543marro_n
marrons93216973marrons
marrow112812603marro_w
marrows122911813marrows
marrowy15236083marrowy
narcoma1145823narcoma
narrow9269143narro_w
narrows10258843narrows
oba57531553___oba
orra46120723orr__a
parrot8320663parro_t
parrots9312743parrots
parroty1247863parroty
proa66229963_pro_a
probe94320813_probe
pyrola1139003pyrola
ramona8412413ramona
rioja1236303_rioja
rob56754303__rob_
robe65335643__robe
robs65837873__robs
rota45834343__rota
rumba93612513_rumba
saprobe1137333saprobe
sarcoma1147403sarcoma
scrota8310183scrota
serosa6313023serosa
soba64927923__soba
strobe84513813strobe
stroma84313073stroma
throb109816853throb_
throbs118311373throbs
trona54118953_trona
unrobe82611673unrobe
variola1068893variola
wardrobe1464133wardrobe
yarrow12287933yarro_w
yarrows13277853yarrows
yerba101010763yer_ba
zareba1736423zareba
zareeba1842423zareeba
zariba1736973zariba

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 Limit1127162055.95318934.3
3Display Results2052050.0762697.4
 (SQL Overall)1786912056.16928966.0
 
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.