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

238 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
grin5573372(None) 
brin67038191brin
gain56042161gain
gin46055751g_in
girn56026861girn
grain65126251grain
gran56335011gran
grid65829611grid
grig65424771grig
grim76929421grim
grind75917561grind
grins65427221grins
grip76127021grip
grit55247241grit
groin65521081groin
rin36663181_rin
again65218122again
agin56132712agin
agria65517142agria
ain37579092_ain
airn46433832airn
akin86328032akin
amin66042252amin
aria46245422aria
arid57642712arid
aril45843022aril
ayin76331742ayin
bin56658642_bin
blin67228172blin
brain76229382brain
bran65740382bran
bren65629562bren
brie65837902brie
brig76528032brig
brim85629372brim
brine75132272brine
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
brio65432492brio
bris65539612bris
brit66350152brit
bruin75818332bruin
burin75626062burin
cain65643912cain
chin96934742chin
coin66645352coin
crib86323582crib
cris66233432cris
crit65743712crit
din46459462_din
djin12911632djin
drain65222892drain
drib76823262drib
drink106816382drink
drip76223952drip
ern35738352er_n
fain75840562fain
fin66458032_fin
firn76927502firn
foin77231562foin
frig85424502frig
frit77044472frit
friz166324342friz
gaen57329602gaen
gains65729512gains
gait56150192gait
gamin84423002gamin
gan48060132g_an
garni6315702garni
gaun56427712gaun
gen45950512g_en
ghi77019882ghi_
ghis85020162ghis
gib66443532g_ib
gid57047262g_id
gie47149542g_ie
gien56330022gien
gig56040752g_ig
gink97129522g_ink
gins55543952g_ins
gip67645362g_ip
gird65424992gird
girl56226552girl
girns64516802girns
giro55828632giro
giron66118992giron
girt56646422girt
git46266052g_it
glen56027202glen
glia56423152glia
glib79421442glib
glim76026352glim
glint66830182glint
going75218492going
goon57236172goon
goring84119572goring
gown85724072gown
grab75427612grab
grad66829862grad
gradin83517482gradin
grail64622872grail
grains74223092grains
grainy103914212grainy
gram77034582gram
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
grat55651282grat
gratin74520582gratin
gray85329892gray
gree56641562gree
green65522142green
grew85620262grew
grey85624042grey
gride75223582gride
grids75321392grids
grief95319782grief
griff124416462griff
grift95924462grift
grigs75318192grigs
grill64617892grill
grime85021322grime
grimy114312602grimy
grinch1238472grinch
grinds84511842grinds
gringa838552gringa
gringo838642gringo
griot65328412griot
gripe84622962gripe
grips85520132grips
gript85126172gript
gripy115115252gripy
grison7310102grison
grist65529872grist
grith95520372grith
grits65529582grits
groan65618422groan
grog65923342grog
groins73917202groins
grok95819682grok
grot55942052grot
grow86127302grow
grown95317352grown
grub77220082grub
grue55825712grue
grum75625082grum
grunt65523542grunt
guan55325582guan
guid66022822guid
gun47240802g_un
gwine95513662gwine
gyri85415152gyri_
gyring113910362gyring
gyron95314622gyron
hin67559562_hin
in28150862__in
irid55927172irid
iring66025422iring
iris45732552iris
iron46728462iron
jin106443932_jin
join116724832join
kain85334292kain
kin76353962_kin
kirn87123432kirn
kris86423602kris
lain46146282lain
lin37967372_lin
loin46838722loin
main65345522main
mirin75023152mirin
orcin72716572orcin
orpin73415532orpin
pain65647242pain
pein65834942pein
pin57066722_pin
pirn67128372pirn
prig75924872prig
prim85132202prim
prink114719672prink
print74837462print
prion75119992prion
purin75527592purin
pyin96823232pyin
quin135823922quin
rain46251732rain
ran38266622_ran
rein46040892rein
ria36745502_ria
rib56848032_rib
rid46754622_rid
rif65951562_rif
rig46748122_rig
rim56052272_rim
rind56535602_rind
ring56541152_ring
rink87736992_rink
rins46153192_rins
rip56851302_rip
ruin47430512ruin
run36244982_run
sain45551292sain
sarin55239252sarin
serin55434442serin
shin75634312shin
sin36265892_sin
skin85927532skin
spin66231302spin
sri35634002sri_
sris45434152sris
tain45548072tain
thin76732392thin
tin36362172_tin
train56529112train
trig55528162trig
trim65329522trim
trine54734602trine
trio45233342trio
trip66830392trip
twin76023082twin
tyin76424002tyin
uric63624932uric
urine55026592urine
urn35731462ur_n
vain75233002vain
vein75625752vein
wain75840202wain
whin105225692whin
win66456292_win
wren78221682wren
wring95920712wring
writ75537912writ
yin67648732_yin
zein135620602zein
zin125643772_zin

Search took 1 second 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 Filter178691298720.0762351197.4
2DLD Change Limit298722380.83035990.4
3Display Results2382380.0465173.9
 (SQL Overall)1786912380.952187700.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.