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

203 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
pagoda1048787(None) 
pagod95013681pagod_
pagodas11367551pagodas
pagods105310191pagods
agora6914332_agora
dagoba1074942dagoba
paged95926782paged_
pakora1247282pakora
panada94113052panada
panda85022612pa_nda
parody12410092parody
payola11208112payola
abode85518813_abode
aboma91114603_aboma
aga410447233_ag__a
agama85815583_agama
aged67334253_aged_
agenda837253_agenda
aggada955223aggada
agha87417303_ag_ha
agita6315423_agita
agma77623263_ag_ma
ago48845523_ago__
agog68019003_ago_g
agon56531883_ago_n
agonal7410053_agonal
agone65924553_agone
agons66423783_agons
agony96415653_agony
agorae7511203_agorae
agoras7613343_agoras
agria65517143_agria
alodia71112453_alodia
aloha8513613_aloha
angora71111573angora
anoa45634473_ano_a
anodal72512123_anodal
anode65021043_anode
apagoge11164683apagoge
apnoea867093apnoea
apod78123183_apod_
apodal9289833_apodal
apods86316343_apods
aroma71220143_aroma
banda85223103ba_nda
caeoma1039033caeoma
caged95426363caged_
canola8313623canola
coda77029343__coda
dada66422443da__da
dagga839543dag_ga
dago65725093dago__
dagobas1145143dagobas
dagoes85714603dagoes
dagos76419443dago_s
fagot9323403fago_t
fagots1039963fagots
gaga66625553gag__a
gaged85522313gaged_
garda7316763ga_rda
goa47343803__go_a
goad66830983__goad
god57449793__god_
gods65438043__gods
hagdon1188283hagdon
haggada1353643haggada
hagrode1236443hagrode
hamada1239923hamada
jagra1338173jag_ra
lagoon7410483lagoon
laguna7127223laguna
lambda1146113lambda
magma104513573mag_ma
magot8326393mago_t
magots9312363magots
nada58022903na__da
nagana748943nagana
oda48133043___oda
paca85132243pa__ca
paced106931683paced_
pacha126518063pa_cha
pad68057323pa__d_
paddy125913593pa_ddy
padi76331783pa__di
padouk1336683padouk
pads76742953pa__ds
paella8410913paella
paeon74819493paeo_n
paeons83915523paeons
pagan86121163pag_an
pagans95717923pagans
page76036103pag__e
pager84728203pag_er
pagers94423253pagers
pages85235073pag_es
paginal10269493paginal
paging104020403paging
paid75737483pa_id_
paisa76021073pa_isa
pajama17317653pajama
pakeha1533933pakeha
pakoras1337473pakoras
palapa10310673palapa
palea75028663pa_lea
paled85538723paled_
pallia83015593pallia
palooka1344503palooka
paludal1035683paludal
pampa114913423pa_mpa
panadas103312213panadas
panama104213353panama
pandas95521963pa_ndas
pandora1039543pandora
pandy115021173pa_ndy
paned85437183paned_
panga85323533pa_nga
panged104722333panged_
panocha1444983panocha
papa85827143pa__pa
papadam1486913papadam
papaya1337503papaya
papula103011113papula
para65242173pa__ra
parade94720643parade
pard76441323pa_rd_
pardah123412823pa_rdah
pardi85723953pa_rdi
pardon94618733pardon
pards85634333pa_rds
pardy115523953pa_rdy
pared86946763pared_
parged104922043parged_
pargo86723723pargo__
pargos95719043pargo_s
parka115120883pa_rka
parodic122311723parodic
parodoi10267723parodoi
parodos103011753parodos
parol74826273paro_l
parole84425253parole
parols84722613parols
parous84024163parous
parura8310583parura
pasha105417183pa_sha
pasta76624533pa_sta
pataca10311193pataca
pated85237843pated_
patina86022193patina
patois84319363patois
paved115525263paved_
pavid115717003pavid_
pavlova1542113pavlova
pawed115725613pawed_
payday1536613pa_yday
payed115925933payed_
payload1336403payload
payoff1736023payoff
payolas12148973payolas
payor105413843payo_r
payors114312643payors
payout11714653payout
pelota8612833pelota
pergola1067623pergola
pignora10306363pignora
pigout9314613pigout
plod76723273p_lod_
plods85719293p_lods
plugola1043013plugola
pod66351483p__od_
podia8415283p__odia
pods76540153p__ods
pogonia1048933pogonia
pood75934323p_ood_
poods85124753p_oods
posada937163posada
proa66229963p_ro_a
prod76129503p_rod_
prods85523553p_rods
purda82914693p_urda
pygidia1444193pygidia
pyrola1139003pyrola
raga55930813rag__a
raged74829453raged_
ragout7317183ragout
ramada9310183ramada
ramona8412413ramona
rugola736293rugola
rugosa734563rugosa
saga55331173sag__a
sago56332673sago__
sagos66123873sago_s
samosa8510203samosa
sapota8310213sapota
sarod65325873sarod_
sarode75317513sarode
sarods74918573sarods
soda56329383__soda
vagina102710933vagina
vanda94515923va_nda
waged104822783waged_
wagon94312953wago_n
wagons103911213wagons
zygoma2143493zygoma

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.376475242.0
2DLD Change Limit1127162035.56320261.7
3Display Results2032030.0633222.2
 (SQL Overall)1786912036.00229771.9
 
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.