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

279 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
robalo83893(None) 
robalos937681robalos
cobalt10317392cobalt
rabato83413262rabato
rebato83714682rebato
ribald9209292ribald
roband92310722roband
roble75223022rob_le
romano84912942romano
royal85014702royal_
royals93711262royals
rubato8319682rubato
zocalo1735802zocalo
bal56662723__bal_
bald76432903__bald
bale66353843__bale
balk105132223__balk
ball66043323__ball
balm85534203__balm
bals66354043__bals
bobble94115143bobble
bolo65535953__bolo
boral75831703boral_
borals86721913borals
boxball18155323boxball
bromal10313653bromal_
bromals1139743bromals
bubal94218213bubal_
bubale104014623bubale
bubals103513843bubals
cabal95222153cabal_
cabala103516913cabala
cabals104020153cabals
calo64936443__calo
catalo8314853catalo
cembalo13145533cembalo
coal66939253co_al_
coala77521123co_ala
coals76129603co_als
coaly105521593co_aly
cobalts1139203cobalts
cobble123615263cobble
coble94823173cob_le
comal95125133comal_
copal95621783copal_
copalm125010813copalm
copals105018943copals
coral76033453coral_
corals85325143corals
coxal146116673coxal_
doable93115243doable
dobla84913643dob_la
doblas93812293doblas
doblon938013dob_lon
dobro84412213dob_ro
domal85619203domal_
dorado838813dorado
dotal64919623dotal_
embalm1236653embalm
enhalo987563enhalo
foal76630923fo_al_
foals85721693fo_als
focal104917673focal_
global937663global_
goal55829303go_al_
goals65521293go_als
goban84414073goba_n
gobang10376703gobang
gobans94412043gobans
gobble113512983gobble
gobo76126903gob__o
goral65125753goral_
gorals76917653gorals
halo76437323__halo
hobble133913433hobble
hobo97026083hob__o
hollo84822163ho_llo
horal86328683horal_
imbalm1246323imbalm
joual12311653joual_
jouals1338923jouals
kabala124011553kabala
koala95112213ko_ala
kobo107422103kob__o
kobold1365963kobold
kolo87026223ko__lo
lobar7313013loba_r
lobate82915243lobate
lobo67229863lob__o
lobule82910063lobule
local74820273local_
locale83915653locale
locals83714503locals
loral55927823loral_
lowball1275503lowball
loyal84513483loyal_
mobile103613543mobile
modal85919243modal_
modals93914453modals
modulo9256983modulo
molal75120343molal_
moral75533433moral_
morale85220553morale
morals85324633morals
nobble103814313nobble
noble74420993nob_le
nobly105314403nob_ly
nodal64717793nodal_
nolo46229313no__lo
nopal75517103nopal_
nopals84914023nopals
notal55221353notal_
oba57531553_oba__
obas65730933_oba_s
obeli73711933_obeli
obol65220613_obol_
obole75917143_obole
oboli73712873_oboli
obols73715863_obols
oorali6311263oorali
opal66923523_opal_
opals75718353_opals
oral47638123_oral_
orals55826483_orals
oval77119523_oval_
ovals85413393_ovals
ovolo8339173_ovolo
pedalo93811153pedalo
pibal95217323pibal_
pibals103813083pibals
poblano1145093poblano
polo66236633po__lo
pomelo10238663pomelo
potato8513433potato
probable1439053probable
probably1746413probably
proband122710243proband
probang12278383probang
probate11414483probate
qabala17399193qabala
rabat72832223raba_t
rabatos93010903rabatos
rabats83116223rabats
rabble103818243rabble
rale45050563r__ale
ramal74622243ramal_
ratal55025113ratal_
ratals64219583ratals
rato45436973r__ato
real45750293r_eal_
realm75621623r_ealm
reals55038653r_eals
rebait8320403rebait
rebar75420193reba_r
rebars84019833rebars
rebate84424113rebate
rebatos92913113rebatos
rebel73421293rebel_
rebels84518133rebels
rebill84713253rebill
rebozo1737323rebozo
recall83815723recall
refall94314393refall
regal65023793regal_
regale74821453regale
renal55929503renal_
resale64025543resale
rial45938093r_ial_
rials55026673r_ials
rialto638603r_ialto
ribalds10236673ribalds
riband9239623riband
rival85216503rival_
rivals94213183rivals
riyal84413433riyal_
riyals94111083riyals
roach105717003ro_ach
road56332113ro_a_d
roadeo7510323roadeo
roads66523623ro_ads
roam67132413ro_a_m
roams74919613ro_ams
roan47234203ro_a_n
roans54926443ro_ans
roar46328573ro_a_r
roars55622243ro_ars
roast56230143ro_ast
rob56754303rob___
robands10219863robands
robbed113415193robbed
robber103916533robber
robbin103611183robbin
robe65335643rob__e
robed85323733rob_ed
robes75133303rob_es
robin74820283rob_in
robing93618003robing
robins83617453robins
robles85321693robles
robot7325973rob_ot
robots8313153robots
robs65837873rob__s
robust8310433robust
rococo1036813rococo
rodeo65921093ro_deo
roil46235293ro_il_
roils54826793ro_ils
roily86121113ro_ily
role45851823ro__le
rolf75134873ro__lf
roll46331653ro__ll
rolls55326233ro_lls
romaji1534893romaji
roman75424823roma_n
romanos94311483romanos
romans84620243romans
romeo73719703ro_meo
rondo65218373ro_ndo
rootle63214453rootle
ropable111611333ropable
ropily113312443ropily
rosary92810353rosary
rosily93914713rosily
rosolio746983rosolio
rota45834343rota__
rotary92411303rotary
rotas54827723rota_s
rotate63320343rotate
rotator7310833rotator
rotl45029683ro_tl_
rotls55620163ro_tls
roto45935053ro__to
rouble83913313rouble
rowable121510303rowable
rowan85418733rowa_n
rowans95715343rowans
rowel84721413rowel_
rowels94515453rowels
royally13157733royally
royalty13165113royalty
rubaboo1144093rubaboo
rubace10310173rubace
rubati8299693rubati
rubatos9278653rubatos
rubble104315673rubble
rubbly133710613rubbly
rubel75416833rubel_
rubels84112993rubels
rubigo935053rubigo
ruble74521253rub_le
rugal65916093rugal_
rural55821173rural_
sabal75422483sabal_
sabals84618863sabals
soba64927923soba__
sobas74424253soba_s
solano65314183solano
solo45538943so__lo
tapalo839793tapalo
tobacco1342843tobacco
tomato8313453tomato
tombal102311023tombal_
tombolo1146103tombolo
tonal53724303tonal_
total55321823total_
totals63115163totals
tribal8611133tribal_
tribals9610753tribals
tubal75517203tubal_
unbale83616403unbale
vocal104715643vocal_
vocals113811583vocals
woald94813073wo_ald
wobble133212313wobble
wobbly16347093wobbly
yobbo1237873yob_bo
zocalos1835393zocalos
zoeal144813783zoeal_
zonal145116853zonal_

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.406440125.6
2DLD Change Limit1127162795.65619928.6
3Display Results2792790.0933000.0
 (SQL Overall)1786912796.15529031.8
 
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.