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

244 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
rialto63860(None) 
rialtos736611rialtos
alto47831262__alto
rato45436972r_a_to
realtor73611352realtor
realty92713692realty
rial45938092rial__
rials55026672rial_s
riant55833152riant_
riata54618022ria_ta
righto104111092righto
smalto84410282smalto
also46423443__also
alt36467963__alt_
altho86312603__altho
altos55822953__altos
alts46639903__alts
anatto6139913anatto
aristo6414033ari_sto
arnatto7145073arnatto
auto47432083__auto
biali73419073bial_i
bialis83617163bialis
bialy105119323bial_y
bialys11387913bialys
bilbo95513613bi_lbo
brillo84211003bri_llo
calo64936443_cal_o
canto74931013_canto
chalot113020133chalot
ciao64924183cia__o
criollo943953criollo
dalton7311273_dalton
dato56129943_da_to
datto65416423_datto
dealt65234283dealt_
dial55935063dial__
dialed84716453dialed
dialer74315433dialer
dialog837973dialog
dials64925343dial_s
diatom939453dia_tom
diazo15310033dia_zo
diglot83014333diglot
dilate73220693dilate
dilator82712783dilator
dildo71911773di_ldo
ditto65315603di_tto
exalt123018533exalt_
exalts13328313exalts
fealty122910223fealty
fiasco11104923fiasco
fiat76646643fia_t_
fiats85324483fia_ts
fillo84319783fi_llo
filo76034283fi_l_o
filth115015823fi_lth
finito9310303finito
frailty1335663frailty
gelato73812953gelato
giant65430593giant_
giants74713503giants
giglot84013133giglot
gilt56348543gi_lt_
gilts64924263gi_lts
hallo85127553_hallo
halo76437323_hal_o
halt76056303_halt_
halts85230103_halts
health124712143health
hidalgo1242373hidalgo
hillo84721653hi_llo
hilltop1244783hilltop
hilt75850713hi_lt_
hilts86924413hi_lts
igloo6410493_igloo
into45026153_i_nto
irate55627983ira_te
jato115822683_ja_to
jiao115017843jia__o
jilt115839423ji_lt_
jilts124717413ji_lts
kilo86028663ki_l_o
kilt86144413ki_lt_
kilts95122183ki_lts
kilty125213893ki_lty
lealty92910603lealty
lilo46731563li_l_o
lilt46349943li_lt_
lilts55822803li_lts
malt66254803_malt_
maltol8310843_maltol
malts76331753_malts
malty106721703_malty
milo65536103mi_l_o
milt65455813mi_lt_
milts75430713mi_lts
milty104720073mi_lty
molto75619603_molto
niello636603niello
panto76129413_panto
pial65636703pial__
piano76118713pia_no
pilot77435063pi_lot
pinto75625753pi_nto
quarto153511123quarto
rabato83413263rabato
radio64922493r_adio
raft76245913r_aft_
rafts87820633r_afts
ragtop936683r_agtop
rail46147763rail__
railed74727543railed
railer64524933railer
rails55937403rail_s
raita54623073r_aita
rale45050563r_al_e
rales54947493r_ales
rally84725903r_ally
ralph1078743r_alph
rant45864673r_ant_
rants55935343r_ants
rapt67245313r_apt_
raptor83912823r_aptor
rat37892743r_a_t_
rate45458763r_a_te
rath76037663r_a_th
ratio55227583r_atio
ratos55528763r_a_tos
rats46260373r_a_ts
ratton64116123r_atton
ratty84819593r_atty
react74634333react_
reactor93011653reactor
reacts83616603reacts
real45750293real__
realer63528593realer
reales64934123reales
realia6314593realia
reality10313573reality
reallot7312133reallot
really93315613really
realm75621623real_m
realms84913493realms
reals55038653real_s
realter73716313realter
realtors82811683realtors
reata54225393rea_ta
rebato83714683rebato
recto74520803r_ecto
relate64033633relate
relator74016363relator
replot83818593replot
ria36745503ria___
riantly1037613riantly
rias45540593ria__s
riatas63915093riatas
ribald9209293ribal_d
ribalds10236673ribalds
riblet84222443riblet
riblets93412553riblets
ridley10169543ridley
ridotto844323ridotto
riel46432383riel__
riels55121333riel_s
rifle85518333rifl_e
rifled104115003rifled
rifler94014263rifler
rifles94217703rifles
riflip1134723riflip
rift75642333ri_ft_
rifts85718643ri_fts
right94430503right_
rights104019333rights
righty135011833righty
rile45650533ri_l_e
riled65833253ri_led
riles55343643ri_les
riley84420583ri_ley
rill45140903ri_l_l
rille55728733ri_lle
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
rillets74216153rillets
rills55032713ri_lls
riot45947213ri_ot_
riots54922013ri_ots
ripstop1174763ripstop
risotto744323risotto
rite45849453ri__te
ritz135129983ri__tz
rival85216503rival__
rivaled1138933rivaled
rivalry1354033rivalry
rivals94213183rival_s
rivet85636363rivet_
rivets94417113rivets
riyal84413433riyal__
riyals94111083riyal_s
roadeo7510323roadeo
roast56230143roast_
roasts64915413roasts
robalo838933robal_o
rolltop944043rolltop
roto45935053r__oto
royalty13165113royalty
rubato8319683rubato
salt45758523_salt_
salts55431883_salts
salty85524383_salty
salvo84415643_salvo
santo56227283_santo
shalt85534483shalt_
sial45938833sial__
sialic8313633sialic
sialid7314943sialid
sials54227243sial_s
silo46037913si_l_o
silt46558193si_lt_
silts55330823si_lts
silty84721633si_lty
smalt74729333smalt_
smalti84111183smalti
smaltos9408193smaltos
smalts85214893smalts
tanto55724943_tanto
tilt46252423ti_lt_
tilth85515363ti_lth
tilts55325613ti_lts
trial54926353trial__
trials64319883trial_s
urial54823023urial__
urials64415193urial_s
vial76731093vial__
vialed105112593vialed
vials85822383vial_s
viator93211833via_tor
waltz17615473_waltz
wealth12379223wealth
wilco1039443wi_lco
wilt76246293wi_lt_
wilts85023503wi_lts
zealot15313473zealot

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.1431249587.4
2DLD Change Limit1127162446.23318083.7
3Display Results2442440.0633873.0
 (SQL Overall)1786912446.43927751.4
 
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.