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 “papa” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

236 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
papa8582714(None) 
kapa106021291kapa
napa66927261napa
paca85132241paca
pampa114913421pampa
pap76758401pap_
papal95820671papal
papas94927491papas
papaw125112491papaw
paps86443451paps
para65242171para
pupa85422811pupa
tapa65129141tapa
aa219179952_a_a
aba512850952_aba
aga410447232_aga
aha611246642_aha
ala312463602_ala
ama510853302_ama
ana39559822_ana
ape57251182_ape
apo511142122_apo
app76827602_app
appal95315222appal
apps86319692apps
apt57352542_apt
ava610139322_ava
awa611939672_awa
baa510650422ba_a
baba88828342baba
bap76455842bap_
baps86040842baps
caca85528082caca
cap76758982cap_
cape87242782cape
caph116623292caph
capo85829212capo
caps87147892caps
casa65630862casa
dada66422442dada
dap66652452dap_
daps77239162daps
data56026652data
dopa77220902dopa
fava106820262fava
gaga66625552gaga
gala55635162gala
gama77035512gama
gap67055612gap_
gape75134512gape
gaps76042972gaps
gapy106320912gapy
haha107821062haha
hap87360052hap_
hapax1739322hapax
haps96443462haps
japan14411232japan
jape134923422jape
java147316642java
kaka76518682kaka
kalpa114512192kalpa
kana85928522kana
kapas116021732kapas
kaph135815752kaph
kappa13469742kappa
kata85626022kata
kava115819702kava
lama66635292lama
lap58565272lap_
laps66848872laps
lava76725422lava
lipa68425922lipa
mama86231582mama
mana65341942mana
map77255112map_
maps86141042maps
mara67444562mara
masa65034712masa
maya95824582maya
nada58022902nada
nala46930392nala
nana46632892nana
nap56753202nap_
napas75924352napas
nape65230802nape
nappa98511862nappa
naps66238582naps
nipa69421632nipa
pa410456482__pa
pac79054082pa_c
pacas96029402pacas
pace86345772pace
pacha126518062pacha
pack125535442pack
pacs85842182pacs
pact86648722pact
pacy115328682pacy
pad68057322pa_d
padi76331782padi
pads76742952pads
paean77222722paean
pagan86121162pagan
page76036102page
pah88853592pa_h
paid75737482paid
paik105726802paik
pail66141832pail
pain65647242pain
pair66031512pair
paisa76021072paisa
pal56761672pa_l
palapa10310672palapa
pale66055012pale
palea75028662palea
pall65039342pall
palm85331362palm
palp85828572palp
palpal104112052palpal
palpi95414552palpi
palps94719562palps
pals66951352pals
paly95835532paly
pam77858392pa_m
pampas124913992pampas
pams85641762pams
pan58466442pa_n
panda85022612panda
pane64950282pane
pang75336282pang
panga85323532panga
pans65855722pans
pant66061252pant
papacy1547492papacy
papain10313792papain
papaws13419112papaws
papaya1337502papaya
paper95128662paper
pappi84810892pappi
pappy114713802pappy
papula103011112papula
par57467022pa_r
parae76335702parae
paras76143042paras
pard76441322pard
pare66760842pare
park105237492park
parka115120882parka
parr65731152parr
pars67560792pars
part65967462part
pas58775742pa_s
pase65346862pase
pash95638132pash
pasha105417182pasha
pass65239952pass
past65959012past
pasta76624532pasta
pat58089462pa_t
pate65350462pate
path99134912path
pats66460852pats
paty95234562paty
pavan106518472pavan
pave96133892pave
paw87651172pa_w
pawl95123262pawl
pawn94625302pawn
pawpaw1653502pawpaw
paws96038182paws
pax127346852pa_x
pay88461182pa_y
pays95940222pays
pea56657242p_ea
pep76447082pep_
pepla9312862pepla
pepo87622152pepo
peps85134512peps
pia56848032p_ia
pica85831492pica
pika106322952pika
pima85428652pima
pina65842632pina
pip78051042pip_
pipal95118352pipal
pipe86434432pipe
pips85837132pips
pipy115421512pipy
pita65436432pita
playa105812942playa
plaza164311062plaza
plea66830602plea
pop76252252pop_
pope85535612pope
poppa8409892poppa
pops86340952pops
proa66229962proa
puja135714922puja
pula65129372pula
puma85424122puma
puna65331652puna
pup76339882pup_
pupae96515642pupae
pupal97616872pupal
pupas95219282pupas
pups86032232pups
pupu87620712pupu
pya87023752p_ya
raga55930812raga
raia46638382raia
raja117918682raja
rap56261962rap_
rape65041632rape
raps66247732raps
rapt67245312rapt
raya75224822raya
saga55331172saga
salpa75018352salpa
sap56463232sap_
saps65346372saps
spa55730812_spa
taka87623592taka
tala45938052tala
tap57663872tap_
tapas74627712tapas
tape64538142tape
taps66050672taps
taxa116820092taxa
tepa66021682tepa
vara75530882vara
vasa76522972vasa
wap86553372wap_
waps96642082waps
yap85949822yap_
yaps95933522yaps
zap145840692zap_
zaps156826892zaps

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298722360.90333080.8
3Display Results2362360.0633746.0
 (SQL Overall)1786912361.046170832.7
 
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.