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

174 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
arrobas96921(None) 
ararobas1046181ararobas
arroba898661arroba_
acrobat11411812acrobat
acrobats1258342acrobats
aerobat9514472aerobat
aerobats1049842aerobats
aerobes9311492aerobes
araroba945762araroba_
areolas71013862areolas
aromas81018612a_romas
arras55626132arr__as
arriba867682arriba_
arrows92813482arro_ws
arroyos1036532arroyos
auroras7311702auroras
abas68642083a___bas
abbas95918643a__bbas
abomas101113583a_bomas
abroad9310943abro_ad
abrosias1049033abrosias
acerolas1048053acerolas
across8312643acro_ss
adobes94411533a_dobes
adobos9438453a_dobos
aerobe8412403aerob_e
aerobia939463aerobia
aerobic11310213aerobic
aerobics1246833aerobics
aerosat7417183aerosat
aerosats8411013aerosats
aftosas10147153aftosas
agoras7613343a_goras
agrias74315393agr_ias
airbag956963air_bag
airbags1036293air_bags
airboat9512133airboat
airboats1047283airboats
airbus848343air_bus
albas75925393a__lbas
algarobas1252243algarobas
algarrobas135963algarrobas
allobar946663allobar
allobars1046583allobars
alohas9411703a_lohas
amebas10311453a_mebas
amoebas1135973amoebas
amritas939093amritas
anabas8314083a_nabas
angoras8811363angoras
annonas738793annonas
anoas57226493a_no_as
aortas65417783aor_tas
apnoeas946353apnoeas
aporias9315153aporias
aprons8316993apro_ns
apropos1138843apropos
arbores94016033arbores
arbors84717883arbo_rs
arbours93910043arbours
arbs66834733a_r_b_s
ardebs937013ardeb_s
ardors74416873ardo_rs
ardours8368883ardours
areas55935773a_r_eas
arecas84817443a_recas
arenas65021993a_renas
areola6813673areola_
areolae7811733areolae
areolar779223areolar
areoles71016953areoles
arepas85515703a_repas
argalas84011093argalas
argols74514613argo_ls
argons75018203argo_ns
argots74116033argo_ts
arias55438023a_r_ias
ariosos7409853ariosos
aristas7413523aristas
arkoses113910833arkoses
armadas1038173armadas
armors85017813armo_rs
armours9389853armours
arnicas939543arnicas
aroids75118223a_roids
aroma71220143a_roma_
arracks1387733arracks
arrases71214543arrases
array86317143arr__ay
arrayal1055843arrayal
arrayals1154483arrayals
arrays95311683arr_ays
arrear6310253arr_ear
arrears738843arrears
arrests73312683arrests
arris56824683arr__is
arrises71617583arrises
arrival1037563arrival
arrivals1145943arrivals
arrives101311513arrives
arrogant949153arrogant
arrogate91210323arrogate
arrogates10129423arrogates
arrow83414883arro__w
arrowed1148113arrowed
arrowy12288273arro_wy
arroyo936963arro_yo
arsons63917213arso_ns
arugolas944403arugolas
arvos86015663arvo__s
asramas938303asramas
aucubas1145173aucubas
auras55932563aur__as
aureolas846853aureolas
aurochs1245983aurochs
aurora6411763aurora_
aurorae739663aurorae
auroral7310473auroral
aurous64119263auro_us
autobus996513autobus
barrooms1237893barrooms
barrows123411683barro_ws
carboras12311583carboras
cariocas1239663cariocas
carobs104818103carob_s
carroms11512403carro_ms
carrots9714623carro_ts
chromas142512693chromas
cordobas1345803cordobas
coronas93916913coronas
dagobas1145143dagobas
earlobes1056143earlobes
enrobes92211113enrobes
erratas736863erratas
errors63311313erro_rs
farrows13259783farro_ws
garrons82713463garro_ns
garrotes969363garrotes
harrows132611033harro_ws
jerboas1636163jerboas
jojobas1542233jojobas
karroos1139313karro_os
madronas11288493madronas
marimbas1444363marimbas
marrons93216973marro_ns
marrows122911823marro_ws
narcomas1246043narcomas
narrows10258843narro_ws
obas65730933___obas
parrots9312743parro_ts
proas75028803_pro_as
probes104119453_probes
pyrolas1239863pyrolas
ramonas9311093ramonas
riojas1335813_riojas
robes75133303__robes
robs65837873__rob_s
rotas54827723__rotas
rumbas102512013_rumbas
saprobes1237033saprobes
sarcomas1247223sarcomas
serosas7312663serosas
sobas74424253__sobas
strobes93813263strobes
throbs118311373throb_s
tronas63816903_tronas
unrobes9269733unrobes
variolas1168533variolas
wardrobes1583793wardrobes
yarrows13277853yarro_ws
yerbas11119293yer_bas
zarebas1836303zarebas
zareebas1943103zareebas
zaribas1836043zaribas

Search took 8 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.390458182.1
2DLD Change Limit1340271747.06318975.9
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.51623774.7
 
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.