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

242 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
ramadas103930(None) 
armadas1038171armadas
hamadas1339661hamadas
ramada9310171ramada_
armada938782armada_
hamada1239912hamada_
hammadas1644782hammadas
kamalas13339122kamalas
lambadas1354872lambadas
lambdas1246242lambdas
panadas103312212panadas
ramblas112710262ramblas
ramonas9311092ramonas
remudas1035832remudas
samaras9312912samaras
abacas104414723_abacas
abakas123911743_abakas
abayas114011703_abayas
agamas97413443_agamas
aggadas1054983aggadas
alamedas1145443alamedas
amadou977593_amadou
amadous1038473_amadous
amahs107819063_ama_hs
amas67746293_am__as
amass77119683_ama_ss
amazes175613473_amazes
amebas10311453_amebas
amias75831463_am_ias
amidase1036723_amidase
amides95722663_amides
amids85627503_amid_s
amigas95912163_amigas
anabas8314083_anabas
aramids102810503aramid_s
arcades101113193arcades
arcadias1149153arcadias
argalas84011083argalas
asanas6514113_asanas
balatas9311833balatas
bananas93312223bananas
bandas95120543ba_ndas
bemadam1445773bemadam
bemadams1543383bemadams
bravados1443213bravados
cabalas113516003cabalas
cabanas112413033cabanas
camails11311743camails
camas96333523cam__as
camases114216343camases
camass104114183cama_ss
cameras11313343cameras
camisas113411923camisas
casabas1139983casabas
casavas1237813casavas
chamades16138633chamades
cicadas1235983cicadas
dadas75819863__dadas
damages11511273damages
damans94715983dama_ns
damars93814993dama_rs
damasks1435073damasks
damianas1155573damianas
dramadies1344803dramadies
dramady1443553dramad_y
dramas95814653dram__as
facades1339033facades
faraday1445633faraday
faradays1544273faradays
farads104713273farad_s
gamas85431353gam__as
gamays126310903gama_ys
gambades1435863gambades
gambados1444143gambados
gambas115817513gam_bas
gambias125010723gambias
gammas115714693gam_mas
geladas936313geladas
gramas94317193gram__as
grammas12499763gram_mas
grampas12399253gram_pas
gravidas13285803gravidas
haggadas1463613haggadas
halalas104214083halalas
hamadryas1842193hamadryas
hamals114816813hama_ls
hamates122917673hamates
hamauls12387803hamauls
hammada1545083hammada_
hamzas20119013ham_zas
hawalas13348353hawalas
jacanas1638263jacanas
jemadar1743373jemadar
jemadars1842543jemadars
kabakas12367403kabakas
kabalas133911063kabalas
kabayas16316803kabayas
kamala12339963kamala_
kanakas10327213kanakas
lamas75532793lam__as
lambada1245643lambada_
lambda1146113lambda_
lamedhs13444703lamedhs
lameds94812033lamed_s
lamias85020613lam_ias
laminas93615873laminas
lampads12477623lampad_s
lampas106615953lam_pas
macadam1446853macadam
macadams1545093macadams
madam10316223__madam
madams11310943__madams
madras94316423__madras
mads76845363__mad_s
mamas95930773__mamas
mambas125716243mam_bas
mammas94616403mam_mas
mananas93414733mananas
manas76240423__manas
maracas11313773maracas
maras75443283__maras
masalas9312053masalas
masas75630413__masas
mayas105924383__mayas
nadas66320813__nadas
naganas847983naganas
naiades838213naiades
naiads739013naiad_s
nomads94711603nomad_s
pagodas11367553pagodas
pajamas18278153pajamas
palapas11311493palapas
pampas124913993pam_pas
panada94113053panada_
panamas113112753panamas
pandas95521963pa_ndas
papadam1486913papadam
papadams15104783papadams
papayas1437273papayas
parades104121463parades
parados103816053parados
patacas11311003patacas
pomades123711733pomades
posadas1037193posadas
qabalas18289503qabalas
rabatos93010893rabatos
rabats83116223raba_ts
radar61316723r__adar
radars71314663rada_rs
rads56046603r__ad_s
radulas839573radulas
raffias13237713raffias
ragas65326063r__agas
raias54631123r__aias
raids65827513ra_id_s
raitas64417673ra_itas
rajahs16497663raja_hs
rajas127317723r__ajas
ramal74622243ram__al
ramate83921673rama_te
rambla103510933rambla_
rambles113118313rambles
ramees84620893ram_ees
ramets83517393ram_ets
ramies84630463ram_ies
ramjets1635163ramjets
rammers113715043rammers
ramona8412413ramona_
ramous8417103ram_ous
rampages1336673rampages
ramparts1245583ramparts
ramps96224633ram__ps
ramrods1036583ramrods
rams65950773ram___s
ramsons939563ramsons
ramtils938413ramtils
ramus76418283ram__us
randan7315253ra_ndan
randans8313213randans
rands65930453ra_nd_s
ranids75118703ranid_s
ranulas7311763ranulas
raphias123511083raphias
rapids94913893rapid_s
ratafias1145323ratafias
ratals64219583rata_ls
ratans63819373rata_ns
ratatat7412263ratatat
ratatats846063ratatats
ravages1139403ravages
rayahs12579193raya_hs
rayas85922053r__ayas
readds84111643r_eadds
reads64835273r_ead_s
reatas64021013r_eatas
remade94316983remad_e
remails94714563remails
remains94117893remains
remakes134116173remakes
remands104914883remands
remans84823003rema_ns
remaps105012873rema_ps
remarks13329983remarks
remates93827103remates
remoras9314073remoras
remuda936823remuda_
resedas839123resedas
riatas63915083r_iatas
roads66523613r_oad_s
romajis1635903romajis
romanos94311473romanos
romans84620243roma_ns
ruanas6311263r_uanas
rumakis1335523rumakis
rumbas102512013rum_bas
salads75316963salad_s
samadhi1344053samadhi
samadhis1444253samadhis
samara8313853samara_
sambas104219263sam_bas
samosas939293samosas
samsaras1045873samsaras
sataras7315053sataras
tamales93216143tamales
tamals84116623tama_ls
tamanduas1242563tamanduas
tamandus1143943tamandus
tamarao977583tamarao
tamaraos10105883tamaraos
tamarau9107043tamarau
tamaraus1096183tamaraus
tamaris9413573tamaris
tamashas13135683tamashas
tambalas1237033tambalas
tampalas1245473tampalas
taramas9612693taramas
vandas103915993va_ndas
wakandas1643413wakandas
yamalkas1743103yamalkas
zamarras1943803zamarras
zamias174212923zam_ias
zananas16319563zananas

Search took 9 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.1561145455.1
2DLD Change Limit1340272427.86017051.8
3Display Results2422420.0932602.2
 (SQL Overall)1786912428.10922036.1
 
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.