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

300 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
grippy1444776(None) 
drippy14445651drippy
gripey124111201gripey
grippe115310321grippe
gripy115115251gri_py
trippy13457801trippy
chippy18437612chippy
crappy15446802crappy
crimpy15489392crimpy
crispy13478562crispy
dippy135111542_dippy
flippy1654612flippy
gappy136212032g_appy
gimpy135212232g_impy
gipsy11579542g_ipsy
gloppy1454722gloppy
grapey126012302grapey
grappa11396442grappa
grapy115416432gr_apy
grimly12459932grimly
grimy114312602gri_my
grip76127022gri_p_
gripe84622962gri_pe
griped104114712griped
griper94114612griper
gripes94619872gripes
gripped13419342gripped
gripper124410712gripper
grippes124810372grippes
gripple12416612gripple
grips85520132gri_ps
gript85126172gri_pt
grisly104310582grisly
gritty10338402gritty
grumpy14498152grumpy
guppy135211272g_uppy
hippy155112792_hippy
lippy124511902_lippy
nippy124911112_nippy
preppy1235522preppy
quippy22384262quippy
ripply13348002_ripply
slippy1375842slippy
snippy1374842snippy
tippy125411792_tippy
triply114211022triply
whippy19385842whippy
zippy21518742_zippy
ariary94114203ariary
aridly105513703aridly
briary114912003briary
bricky17489093bricky
briery114510773briery
briny104719663bri_ny
briony1149043briony
buppy144810073_buppy
chirpy16498913chirpy
choppy18376293choppy
crampy154710993crampy
creepy13418803creepy
crepey135110933crepey
crepy124812703cr_epy
crikey15317783crikey
crimp115615803crimp_
crimps124613453crimps
cripe95521143cri_pe
cripes105120873cripes
cripple13378583cripple
crisp95014623crisp_
crisply14426523crisply
crisps104411513crisps
croupy13458733croupy
cuppy144710383_cuppy
drapey125010583drapey
drifty13418223drifty
drily95816523dri_ly
drip76223953dri_p_
dripped13408083dripped
dripper12349233dripper
drippily1643033drippily
drips85417233dri_ps
dript86923873dri_pt
droopy12458243droopy
dropsy12497473dropsy
flappy1654483flappy
floppy1654873floppy
frappe13286953frappe
friary124010093friary
frilly124111443frilly
fringy13309263fringy
frippery1832953frippery
frisky16406673frisky
frizzy20555833frizzy
frumpy16466883frumpy
gaiety10119373gaiety
gaily95020973gai_ly
gainly1049323gainly
gapy106320913g__apy
giddy115810203g_iddy
gilly94321633g_illy
gimp96124043g_imp_
gimps105915203g_imps
ginny95314573g_inny
gip67645363g_i_p_
gipon84212413g_ipon
gipped124815903g_ipped
gipper114215303g_ipper
gips75632923g_i_ps
girly94415293g_irly
glibly1236293glibly
glinty106910693glinty
glitzy19404783glitzy
glumpy14527193glumpy
goopy115816623g_oopy
gorily10612503gori_ly
grabby14336183grabby
grainy103914213grainy
gramp106218323gramp_
grampa115010173grampa
gramps114114273gramps
granny104311163granny
grape84824663gr_ape
grapery13457953grapery
grapes95123123grapes
graph115315613gr_aph
graphs124510153graphs
grappas12357103grappas
grapple12378003grapple
grasp84814483grasp_
grasps9489253grasps
grassy10619093grassy
gravy125512113gr_avy
gray85329893gr__ay
grayly13287963grayly
greasy10419463greasy
greedy11518853greedy
greeny104811453greeny
gremmy1454473gremmy
grey85624043gr__ey
greyly13316543greyly
grid65829613gri__d
gride75223583gri_de
grided95117043grided
grides84422363grides
grids75321393gri_ds
grief95319783gri_ef
griefs10418723griefs
grieve1047243grieve
griff124416463gri_ff
griffe13438093griffe
griffs13398993griffs
grift95924463gri_ft
grifts104511683grifts
grig65424773gri__g
grigri833853grigri
grigs75318193gri_gs
grill64617893gri_ll
grille74315743grille
grills74314803grills
grilse7399503grilse
grim76929423gri__m
grime85021323gri_me
grimed104714093grimed
grimes94619033grimes
grimily1336523grimily
grin55733723gri__n
grinch1238473grinch
grind75917563gri_nd
grinds84511843grinds
gringa838553gringa
gringo838643gringo
grins65427223gri_ns
griot65328413gri_ot
griots74713643griots
gripers104011463gripers
gripier103210323gripier
griping113012063griping
gripman1234463gripman
gripmen1235033gripmen
grippers13358133grippers
grippier1355203grippier
gripping14277543gripping
grison7310103grison
grist65529873gri_st
gristly11187333gristly
grists74716483grists
grit55247243gri__t
grith95520373gri_th
griths105211653griths
grits65529583gri_ts
grivet103517823grivet
grizzly19354473grizzly
grody103412063gr_ody
groggy1234803groggy
groovy13375403groovy
grope84821613gr_ope
groped107515053groped
groper94517253groper
gropes95220403gropes
groszy19395703groszy
grotty10389833grotty
group85413923group_
groups94210513groups
grouty104710983grouty
growly13499173growly
grubby14324503grubby
gruffy16396013gruffy
grump105115313grump_
grumphy18443623grumphy
grumps114510573grumps
grungy11345973grungy
guilty10418233guilty
guimpe1134723guimpe
gulpy114612763g_ulpy
gypsy14636993g_ypsy
happy155813533_happy
hiply134113613_hiply
hippo12369063_hippo
hoppy154912353_hoppy
jimpy195210823_jimpy
loppy125911663_loppy
nappy126312333_nappy
pappy114713803_pappy
peppy114310363_peppy
pipy115421513_pi_py
poppy114813193_poppy
prepay13310313prepay
priapi1037923priapi
pricey134412633pricey
pricky174210343pricky
pricy124814563pri_cy
primly13439623primly
primp115615923primp_
primps124711823primps
priory114110263priory
prissy11347853prissy
privy13439833pri_vy
puppy114912413_puppy
quippu19344863quippu
raspy106511703_raspy
repay104818453_repay
reply104015853_reply
repp85418743_repp_
repps95114343_repps
ribby12419683_ribby
ridgy104110643_ridgy
riley84420583_riley
rimy96621283_ri_my
rindy95717393_rindy
rip56851303_ri_p_
ripe66038923_ri_pe
riped85226433_riped
ripely112511153_ripely
ripen75619263_ripen
riper74328403_riper
ripes75435773_ripes
ripped114419013_ripped
ripper103518653_ripper
ripple103413913_ripple
rips66237433_ri_ps
risky126311523_risky
ritzy175611163_ritzy
ropey106021873_ropey
ropy96323413_r_opy
roupy106112713_roupy
sappy125413473_sappy
scrappy16234473scrappy
scrimpy16486133scrimpy
shrimpy17415403shrimpy
sirupy11377053sirupy
skimpy17475723skimpy
sloppy1395303sloppy
snappy1366103snappy
soppy125113523_soppy
strappy14205263strappy
stripy115812743stri_py
stroppy14205093stroppy
tipsy106010503_tipsy
trampy13499253trampy
tricky154211473tricky
trigly103810943trigly
trilby1144973trilby
trimly114410893trimly
trip66830393tri_p_
tripe75425383tri_pe
tripes85324873tripes
triple84215923triple
tripod9399853tripod
tripody13395983tripody
tripos84014923tripos
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
trips74923363tri_ps
trophy1438283trophy
wimpy155911923_wimpy
wispy137210973_wispy
wristy12509703wristy
yuppy15487913_yuppy
zappy21548943_zappy

Search took 6 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.373479064.3
2DLD Change Limit1127163005.08022188.2
3Display Results3003000.0933225.8
 (SQL Overall)1786913005.54632219.8
 
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.