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

186 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
gride7522359(None) 
bride86425541bride
glide74521601glide
grade75126091grade
grid65829621grid_
grided95117041grided
grides84422361grides
grids75321401grids
grime85021321grime
gripe84622961gripe
guide75019891guide
pride84724741pride
ride55945141_ride
abide86223722abide
aide56045012_aide
amide86128492amide
arid57642722arid_
arider74717742arider
arise56436432arise
aside65122092aside
azide155617172azide
bide76041512_bide
boride9415902boride
brede85520502brede
bribe94820782bribe
brides94423512brides
bridge103711882bridge
bridle94115462bridle
brie65837902bri_e
brine75132272brine
chide115321022chide
cried84624292cried
crime94822692crime
cripe95521142cripe
crude86018572crude
deride84420032deride
dried75321382dried
drive95318002drive
eide55832252_eide
elide64922652elide
erode64520992erode
fridge11379252fridge
fried95322912fried
frise85322452frise
geode7412592geode
gibe75927792g_ibe
gid57047282g_id_
gids65933752g_ids
gie47149552g_i_e
gied64631992g_ied
gird65425002gird_
girded93712492girded
girder84312062girder
girdle82110462girdle
girds74817002girds
gite55438622g_ite
give85829362g_ive
glade75121962glade
glede75517832glede
glided94513902glided
glider84614262glider
glides84518862glides
glime85620192glime
grace85124542grace
grad66829862grad_
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
grebe85114942grebe
gree56641562gr_ee
greed75125692greed
greige847202greige
gridded11387582gridded
gridder10367762gridder
griddle1035502griddle
grief95319782grief
grieve1047242grieve
griff124416462griff
griffe13438092griffe
grift95924462grift
grig65424772gri_g
grigs75318192grigs
grill64617892grill
grille74315742grille
grilse7399502grilse
grim76929422gri_m
grimed104714092grimed
grimes94619032grimes
grimy114312602grimy
grin55733722gri_n
grind75917562grind
grinded104210632grinded
grinder93312392grinder
grinds84511842grinds
grins65427222grins
griot65328412griot
grip76127022gri_p
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
grippe115310322grippe
grips85520132grips
gript85126172gript
gripy115115252gripy
grist65529872grist
grit55247242gri_t
grith95520372grith
grits65529582grits
grivet103517822grivet
grody103412062grody
grope84821612grope
grove95219332grove
grudge9388582grudge
grue55825712gr_ue
grume86218162grume
gude65423342g_ude
guid66022832guid_
guided94014112guided
guider84313522guider
guides84118282guides
guids75516162guids
guile64521132guile
guise64717712guise
gwine95513662gwine
hagride1237552hagride
hide85134652_hide
imide85716902imide
irade65618152irade
irid55927182irid_
irides74519122irides
irids66417782irids
nide55535802_nide
oreide7311672oreide
oroide7311702oroide
oxide131210962oxide
price93725412price
prided103618032prided
prides94324182prides
pried84426862pried
prime96525602prime
prise74632612prise
prize164718942prize
prude84615972prude
rede55037682_rede
rice64942922_rice
rid46754642_rid_
rider65231312_rider
rides66140822_rides
ridge75018682_ridge
rids56539562_rids
rife74632332_rife
rile45650542_rile
rime65138892_rime
ripe66038932_ripe
rise45945242_rise
rite45849462_rite
rive75537732_rive
rode55844312_rode
rude55632792_rude
side55444502_side
slide64725422slide
snide64318732snide
stride75420962stride
tide55237392_tide
trade65026042trade
tribe74420272tribe
trice75127492trice
tried65026912tried
trike95320162trike
trine54734602trine
triode75311892triode
tripe75425382tripe
trite54730032trite
trode65322852trode
ureide7310362ureide
urine55026602urine
vide85432772_vide
wide85235422_wide
wried95518562wried
write85522832write

Search took 3 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.310576422.6
2DLD Change Limit538001861.64032804.9
3Display Results1861860.0503720.0
 (SQL Overall)1786911862.00089345.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.