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
gride7522358(None) 
bride86425531bride
glide74521591glide
grade75126091grade
grid65829611grid_
grided95117041grided
grides84422361grides
grids75321391grids
grime85021321grime
gripe84622961gripe
guide75019881guide
pride84724731pride
ride55945131_ride
abide86223712abide
aide56045002_aide
amide86128482amide
arid57642712arid_
arider74717742arider
arise56436432arise
aside65122082aside
azide155617162azide
bide76041502_bide
boride9415902boride
brede85520502brede
bribe94820782bribe
brides94423512brides
bridge103711882bridge
bridle94115462bridle
brie65837902bri_e
brine75132272brine
chide115321012chide
cried84624282cried
crime94822692crime
cripe95521142cripe
crude86018572crude
deride84420032deride
dried75321382dried
drive95318002drive
eide55832242_eide
elide64922642elide
erode64520992erode
fridge11379252fridge
fried95322912fried
frise85322452frise
geode7412592geode
gibe75927782g_ibe
gid57047272g_id_
gids65933742g_ids
gie47149542g_i_e
gied64631982g_ied
gird65424992gird_
girded93712492girded
girder84312062girder
girdle82110462girdle
girds74816992girds
gite55438612g_ite
give85829352g_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
gude65423332g_ude
guid66022822guid_
guided94014112guided
guider84313522guider
guides84118282guides
guids75516152guids
guile64521132guile
guise64717712guise
gwine95513662gwine
hagride1237552hagride
hide85134642_hide
imide85716892imide
irade65618152irade
irid55927172irid_
irides74519122irides
irids66417772irids
nide55535792_nide
oreide7311672oreide
oroide7311702oroide
oxide131210952oxide
price93725412price
prided103618032prided
prides94324182prides
pried84426862pried
prime96525602prime
prise74632612prise
prize164718942prize
prude84615972prude
rede55037672_rede
rice64942912_rice
rid46754632_rid_
rider65231302_rider
rides66140812_rides
ridge75018672_ridge
rids56539552_rids
rife74632322_rife
rile45650532_rile
rime65138882_rime
ripe66038922_ripe
rise45945232_rise
rite45849452_rite
rive75537722_rive
rode55844302_rode
rude55632782_rude
side55444492_side
slide64725412slide
snide64318722snide
stride75420962stride
tide55237382_tide
trade65026042trade
tribe74420272tribe
trice75127492trice
tried65026912tried
trike95320162trike
trine54734602trine
triode75311892triode
tripe75425382tripe
trite54730032trite
trode65322852trode
ureide7310362ureide
urine55026602urine
vide85432762_vide
wide85235412_wide
wried95518562wried
write85522832write

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.326548131.9
2DLD Change Limit538001861.40638264.6
3Display Results1861860.0464043.5
 (SQL Overall)1786911861.778100501.1
 
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.