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

444 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
gypped1537711(None) 
gapped124217121gapped
gipped124815901gipped
gypper14347291gypper
bopped134413402bopped
capped134721852capped
copped135221252copped
cupped134413982cupped
dapped124516762dapped
dipped123517492dipped
dupped124411642dupped
fopped144012672fopped
gaped96123532g_aped
gasped104814292gasped
gawped13509072gawped
gimped123911472gimped
gipper114215302gipper
glopped13347612glopped
griped104114712griped
gripped13419342gripped
groped107515052groped
gulped104610372gulped
gybed125811022gy_bed
gyppers15235502gyppers
gypsied1443262gypsied
gyred105114092gy_red
gyved13568742gy_ved
happed144820102happed
hipped144317692hipped
hopped144318112hopped
hyped145313332hy_ped
hypoed1547922hypoed
kepped15309542kepped
kipped153114572kipped
lapped114320032lapped
lipped114419542lipped
lopped114218622lopped
mapped134015882mapped
mopped134114322mopped
napped114218162napped
nipped113615852nipped
pepped103113402pepped
pipped104516542pipped
popped104117812popped
pupped105013272pupped
rapped114122682rapped
repped114616722repped
ripped114419012ripped
sapped114422012sapped
sipped113720632sipped
sopped114819902sopped
supped114415702supped
tapped113820052tapped
tipped114418262tipped
topped114617722topped
tupped114013232tupped
typed115815452ty_ped
upped103715162_upped
wapped144416472wapped
yapped144415142yapped
yipped143613282yipped
zapped204213522zapped
zipped203612982zipped
aliped95414283aliped
amped104820513_amped
aped78538153__aped
appel94615893_appel
append1138273_append
beeped115313453beeped
biped104718833_biped
blipped14377193blipped
bopper123813833bopper
bumped134414003bumped
burped116215503burped
byrled12437173byrled
camped134720233camped
caped104931803_caped
capper124421983capper
carped115923763carped
chapped172711443chapped
chipped174110813chipped
chopped174511003chopped
clapped143511173clapped
cleped115114113cleped
clipped14439833clipped
clopped143611523clopped
comped135919873comped
cooped114821603cooped
coped105036843_coped
copied114618563copied
copper124321893copper
couped115019313couped
craped116120523craped
crapped143912623crapped
creped114115703creped
cropped143812063cropped
cupper124313863cupper
cusped114312043cusped
cycled1436543cycled
cypher16306593cypher
cypres1338523cypres
damped124315583damped
dapper114016633dapper
dappled1336393dappled
dipper114017793dipper
doped95326713_doped
draped105314363draped
dripped13408083dripped
dropped13329283dropped
dumped123814493dumped
duped95118323_duped
dyed96720763dy__ed
dyked145310953dy_ked
eloped95914143eloped
espied9359773espied
eyed86623233ey__ed
flapped15328253flapped
flipped15358513flipped
flopped15338763flopped
frapped15318853frapped
gabbed125216893gabbed
gabled105518453gabled
gadded103913173gadded
gaed66031513g__aed
gaffed144210203gaffed
gaged85522313g_aged
gagged104817153gagged
gained84617463gained
gaited84416923gaited
galled84622863galled
galoped11138083galoped
gamed95126393g_amed
gammed124216163gammed
ganged94619193ganged
gaoled84814503gaoled
gape75134513g_ape_
gaper86125123g_aper
gapes86030823g_apes
gappier12369843gappier
gappy136212033gapp_y
garbed104815663garbed
garred85217413garred
gashed116321973gashed
gasper94515543gasper
gassed85217633gassed
gasted84821583gasted
gated75329773g_ated
gauged94713473gauged
gaumed104610323gaumed
gawked15468763gawked
gawper12499693gawper
gazed165520333g_azed
geared85317743geared
gecked146911933gecked
ged57044533g___ed
geed65435503g__eed
geeked124510163geeked
gelded94512113gelded
gelled84718893gelled
gemmed12329573gemmed
gibbed124512353gibbed
gibed96215963g_ibed
gied64631983g__ied
gifted114510703gifted
gigged104112293gigged
gilded94413223gilded
gilled84521633gilled
ginned83813983ginned
gippers123212083gippers
gipsied1135873gipsied
girded93712493girded
girned84010513girned
girted83912873girted
gitted84015053gitted
glared84715203glared
glazed174711773glazed
gled65631143g__led
gleed75320573g_leed
gleyed11478153gleyed
glided94513903glided
glimed105312283glimed
globed104811763globed
gloved114811873gloved
glowed114913833glowed
glozed173711223glozed
glued75118363g_lued
gnawed11427833gnawed
goaded94913713goaded
goaled85014363goaled
gobbed124613883gobbed
godded104811803godded
golfed11569763golfed
gonged97115913gonged
goofed114911383goofed
goosed86817033goosed
gopher1239183gopher
gored75227083g_ored
gorged95016983gorged
gormed105013833gormed
gospel936533gospel
gouged96214593gouged
gowned114410133gowned
graced105217903graced
graded94919553graded
grape84824663grape_
grapes95123123grapes
grapey126012303grapey
graphed1498473graphed
grappled14336093grappled
grasped11409063grasped
grated84523923grated
graved114818813graved
grayed115415643grayed
grazed174115913grazed
greed75125693g_reed
greyed114610603greyed
grided95117043grided
grimed104714093grimed
gripe84622963gripe_
griper94114613griper
gripes94619873gripes
gripey124111203gripey
grippe115310323grippe_
gripper124410713gripper
grippes124810373grippes
grope84821613grope_
groper94517253groper
gropes95220403gropes
grouped11419193grouped
groved114413703groved
grumped13337333grumped
guided94014113guided
guiled84315383guiled
guised84612173guised
gulfed114810013gulfed
gulled84521373gulled
gulper93410213gulper
gummed123811663gummed
gunned83513093gunned
guppies123310523guppies
guppy135211273gupp_y
gurged95513363gurged
gushed114816243gushed
gusted84316723gusted
gutted84716363gutted
guyed1049893g_uyed
gybe105916243gy_be_
gybes115012723gy_bes
gyp98319013gy_p__
gypping16305843gypping
gyps105115023gy_p_s
gypsies1335953gypsies
gypster1333953gypster
gypsum1442853gypsum
gypsy14636993gy_psy
gyrated12428413gyrated
gyre84722763gy_re_
gyres94820323gy_res
gyve116215083gy_ve_
gyves125711553gy_ves
happen134812193happen
harped124418403harped
hasped125014443hasped
heaped124516903heaped
helped124714153helped
hepper133412663hepper
hipper133818023hipper
hooped125518183hooped
hoped115628183_hoped
hopper134218483hopper
hoppled15338083hoppled
humped144015243humped
hymned1535323hymned
hype125519813hy_pe_
hyper135213903hy_per
hypes135818673hy_pes
hyphen1736393hyphen
imped105117983_imped
impled113812513impled
japed156217633_japed
jauped16457903jauped
jeeped16469843jeeped
jumped183511553jumped
kelped13449553kelped
keppen14346573keppen
kippen14299013kippen
kipper143414213kipper
knapped16397103knapped
knopped16355453knopped
kythed17407313kythed
lamped114017543lamped
lapper104319953lapper
lappet103817733lappet
lapsed94712583lapsed
leaped94317773leaped
limped114817123limped
lippen103911403lippen
lipper104219633lipper
lisped94113423lisped
looped95217173looped
loped85128333_loped
lopper103717203lopper
louped95316383louped
lumped114216963lumped
lysed95011563ly_sed
mapper124516093mapper
moped105424733_moped
mopper126215003mopper
moppet126915093moppet
mumped133813163mumped
myope124010973myope_
myopes13419963myopes
nappe96114993nappe_
napper103718283napper
nappes104515623nappes
nipper103715713nipper
nippled12307643nippled
oped76230153__oped
opted84914273_opted
palped114513643palped
ped66751523___ped
peed76239183__peed
peeped113915393peeped
pepper93512943pepper
pied75035363__pied
pimped134913483pimped
piped105123163_piped
pled75231433__pled
plopped11288773plopped
pooped113915943pooped
popper93615963popper
poppet92717323poppet
poppied11388983poppied
poppled11339243poppled
prepped11329903prepped
propped113311953propped
pulped114612533pulped
pumped133915563pumped
puppet93514593puppet
quipped2175163quipped
ramped114617903ramped
raped85334623_raped
rappee103618673rappee
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
rasped94715203rasped
reaped94122453reaped
repled93319783repled
riped85226433_riped
ripper103518653ripper
rippled123110273rippled
romped114513653romped
roped84630803_roped
rouped95717353rouped
ryked13669513ry_ked
sapper103822353sapper
scaped115519553scaped
scoped115116653scoped
seeped94317523seeped
shaped125020103shaped
shipped153312103shipped
shopped153512213shopped
siped84927683_siped
sipper103920993sipper
sippet103519393sippet
skipped16358413skipped
slapped123511853slapped
sliped95417063sliped
slipped124711743slipped
sloped94216853sloped
slopped123511443slopped
snapped124611203snapped
sniped94913483sniped
snipped123510043snipped
soaped95817973soaped
souped95017673souped
spaed85522273_spaed
sped76031493__sped
speed85526623_speed
spied85427713_spied
spued84918473_spued
stepped123210053stepped
stiped94517073stiped
stoped94721013stoped
stopped124512203stopped
supper104115433supper
suppled1248463suppled
swapped15429143swapped
swiped123811093swiped
swopped15437673swopped
synced12266963synced
sypher14317083sypher
syruped1334543syruped
tamped114317043tamped
taped85327423_taped
tapper104419613tapper
tappet103820113tappet
temped113912893temped
tipper103918413tipper
tippet103917873tippet
tippled12358393tippled
toped85631313_toped
topper103817603topper
toppled12348843toppled
trapped124512213trapped
tripped123911693tripped
tumped114216233tumped
tyned95915013ty_ned
type96223743ty_pe_
types105721063ty_pes
typey135511883ty_pey
typier1137333typier
typp115812783typp__
typps12549303typp_s
tyred95816433ty_red
tythed13457503tythed
umped104717273_umped
upper93714263_upper
urped84615283_urped
vamped144211013vamped
warped124816413warped
whapped18367573whapped
whipped18379333whipped
whopped18358003whopped
whupped18365413whupped
wimped144211513wimped
wiped114722083_wiped
wisped123411893wisped
wrapped15338023wrapped
wyled124611843wy_led
wyted12529473wy_ted
yapper133714513yapper
yauped12408333yauped
yawed126022453_yawed
yawped15528103yawped
yelped12439363yelped
yipe96722183_yipe_
yipes106017843_yipes
yippee132810743yippee
yoked134821623_yoked
yowed1253025183_yowed
zapper193414023zapper
zipper193813123zipper

Search took 5 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 Limit1127164444.43625409.4
3Display Results4444440.1403171.4
 (SQL Overall)1786914444.95236084.6
 
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.