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

144 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
gripe8462296(None) 
cripe95521141cripe
grape84824661grape
gride75223581gride
grime85021321grime
grip76127021grip_
griped104114711griped
griper94114611griper
gripes94619871gripes
gripey124111201gripey
grippe115310321grippe
grips85520131grips
gript85126171gript
gripy115115251gripy
grope84821611grope
ripe66038921_ripe
tripe75425381tripe
arise56436432arise
bribe94820782bribe
bride86425532bride
brie65837902bri_e
brine75132272brine
crape96128442crape
crepe95520722crepe
crime94822692crime
cripes105120872cripes
drape85319632drape
drip76223952drip_
drips85417232drips
dript86923872dript
drive95318002drive
drupe85012992drupe
frise85322452frise
gape75134512g_ape
gibe75927782g_ibe
gie47149542g_i_e
gip67645362g_ip_
gips75632922g_ips
gite55438612g_ite
give85829352g_ive
glide74521592glide
glime85620192glime
grace85124542grace
grade75126092grade
grapes95123122grapes
grapey126012302grapey
graph115315612graph
grapy115416432grapy
grate64932882grate
grave94624872grave
graze155820052graze
grebe85114942grebe
gree56641562gr_ee
greige847202greige
grid65829612gri_d
grided95117042grided
grides84422362grides
grids75321392grids
grief95319782grief
grieve1047242grieve
griff124416462griff
griffe13438092griffe
grift95924462grift
grig65424772gri_g
grigs75318192grigs
grill64617892grill
grille74315742grille
grilse7399502grilse
grim76929422gri_m
grimed104714092grimed
grimes94619032grimes
grimy114312602grimy
grin55733722gri_n
grind75917562grind
grins65427222grins
griot65328412griot
gripers104011462gripers
gripier103210322gripier
gripmen1235032gripmen
gripped13419342gripped
gripper124410712gripper
grippes124810372grippes
gripple12416612gripple
grippy14447762grippy
grist65529872grist
grit55247242gri_t
grith95520372grith
grits65529582grits
grivet103517822grivet
groped107515052groped
groper94517252groper
gropes95220402gropes
grove95219332grove
grue55825712gr_ue
grume86218162grume
guide75019882guide
guile64521132guile
guimpe1134722guimpe
guise64717712guise
gwine95513662gwine
lipe66839732_lipe
pipe86434432_pipe
price93725412price
pride84724732pride
prime96525602prime
prise74632612prise
prize164718942prize
rape65041632_rape
rice64942912_rice
ride55945132_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
rip56851302_rip_
riped85226432_riped
ripen75619262_ripen
riper74328402_riper
ripes75435772_ripes
rips66237432_rips
rise45945232_rise
rite45849452_rite
rive75537722_rive
rope65542912_rope
sipe67341042_sipe
slipe75626132slipe
snipe75320572snipe
stipe76523372stipe
stripe85822442stripe
swipe105217082swipe
tribe74420272tribe
trice75127492trice
trike95320162trike
trine54734602trine
trip66830392trip_
tripes85324872tripes
triple84215922triple
trips74923362trips
trite54730032trite
trope75725802trope
unripe82012092unripe
urine55026602urine
wipe94830282_wipe
write85522832write
yipe96722182_yipe

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 Filter178691538000.300595636.7
2DLD Change Limit538001441.50035866.7
3Display Results1441440.0304800.0
 (SQL Overall)1786911441.83097645.4
 
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.