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

123 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
grind7591756(None) 
grand75122691grand
grid65829611gri_d
grin55733721grin_
grinds84511841grinds
grins65427221grins
rind56535601_rind
arid57642712ari_d
bind76234512_bind
blind86319322blind
brand85124492brand
brin67038192brin_
brine75132272brine
brined95118412brined
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
cried84624282cried
dried75321382dried
drink106816382drink
find87532602_find
fried95322912fried
friend10388932friend
frond95316342frond
gain56042162gain_
gained84617462gained
gains65729512gains
gerund836162gerund
gid57047262g_i_d
gied64631982g_ied
gild65526512g_ild
gin46055752g_in_
gink97129522g_ink
gins55543952g_ins
gird65424992g_ird
girn56026862girn_
girned84010512girned
girns64516802girns
gland75217712gland
glint66830182glint
going75218492going
goring84119572goring
grad66829862gr_ad
grain65126252grain_
grained93814272grained
grains74223092grains
grainy103914212grainy
gran56335012gran_
grana65722092grana
grands84218242grands
grans64832542grans
grant64840022grant
greed75125692greed
gride75223582gride
grided95117042grided
grids75321392grids
grief95319782grief
griff124416462griff
grift95924462grift
grig65424772gri_g
grigs75318192grigs
grill64617892grill
grim76929422gri_m
grime85021322grime
grimed104714092grimed
grimy114312602grimy
grinch1238472grinch
grinded104210632grinded
grinder93312392grinder
gringa838552gringa
gringo838642gringo
grinned9378552grinned
griot65328412griot
grip76127022gri_p
gripe84622962gripe
griped104114712griped
grips85520132grips
gript85126172gript
gripy115115252gripy
grist65529872grist
grit55247242gri_t
grith95520372grith
grits65529582grits
groin65521082groin_
groined92710812groined
groins73917202groins
ground82310272ground
grunt65523542grunt
guid66022822gui_d
guild75312752guild
gwine95513662gwine
gyring113910362gyring
hind85529752_hind
irid55927172iri_d
iring66025422iring
kind96128552_kind
mind75434382_mind
poind84217912poind
pried84426862pried
prink114719672prink
print74837462print
rand55839572_rand
regrind938982regrind
rend56136572_rend
rid46754622_ri_d
rin36663182_rin_
rinds64826142_rinds
rindy95717392_rindy
ring56541152_ring
rink87736992_rink
rins46153192_rins
rynd86414102_rynd
teind6213612teind
trend64817452trend
triad65217722triad
tried65026912tried
trine54734602trine
trined74920712trined
urine55026592urine
wind85533852_wind
wried95518562wried
wring95920712wring

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.296603685.8
2DLD Change Limit538001231.45337026.8
3Display Results1231230.0304100.0
 (SQL Overall)1786911231.779100444.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.