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

178 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
grip7612702(None) 
drip76223951drip
gip67645361g_ip
grid65829611grid
grig65424771grig
grim76929421grim
grin55733721grin
gripe84622961gripe
grips85520131grips
gript85126171gript
gripy115115251gripy
grit55247241grit
rip56851301_rip
trip66830391trip
agria65517142agria
aria46245422aria
arid57642712arid
aril45843022aril
atrip75315752atrip
blip88322772blip
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
chip116726422chip
clip86924002clip
crap85731842crap
crib86323582crib
crimp115615802crimp
cripe95521142cripe
cris66233432cris
crisp95014622crisp
crit65743712crit
crop87628632crop
dip67848982_dip
drib76823262drib
drips85417232drips
dript86923872dript
drop75324402drop
flip96324262flip
frap95925812frap
frig85424502frig
frit77044472frit
friz166324342friz
gain56042162gain
gait56150192gait
gamp98833212gamp
gap67055612g_ap
gasp76227332gasp
gawp107618632gawp
genip84415202genip
ghi77019882ghi_
ghis85020162ghis
gib66443532g_ib
gid57047262g_id
gie47149542g_ie
gig56040752g_ig
gimp96124042gimp
gin46055752g_in
gips75632922g_ips
gird65424992gird
girl56226552girl
girn56026862girn
giro55828632giro
girt56646422girt
git46266052g_it
glia56423152glia
glib79421442glib
glim76026352glim
glop76724632glop
goop75829482goop
gorp75625902gorp
grab75427612grab
grad66829862grad
grail64622872grail
grain65126252grain
gram77034582gram
gramp106218322gramp
gran56335012gran
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grat55651282grat
gray85329892gray
gree56641562gree
grew85620262grew
grey85624042grey
gride75223582gride
grids75321392grids
grief95319782grief
griff124416462griff
grift95924462grift
grigs75318192grigs
grill64617892grill
grime85021322grime
grimy114312602grimy
grind75917562grind
grins65427222grins
griot65328412griot
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
grippe115310322grippe
grippy14447762grippy
grist65529872grist
grith95520372grith
grits65529582grits
grog65923342grog
groin65521082groin
grok95819682grok
grope84821612grope
grot55942052grot
group85413922group
grow86127302grow
grub77220082grub
grue55825712grue
grum75625082grum
grump105115312grump
guid66022822guid
gulp75521362gulp
gyp98319012g_yp
gyri85415152gyri_
hip86750432_hip
irid55927172irid
iris45732552iris
kip97042132_kip
kris86423602kris
lip514755802_lip
nip56945982_nip
pip78051042_pip
prep86427672prep
prig75924872prig
prim85132202prim
primp115615922primp
prop85932812prop
quip154818622quip
rap56261962_rap
rep55847802_rep
ria36745502_ria
rib56848032_rib
rid46754622_rid
rif65951562_rif
rig46748122_rig
rim56052272_rim
rin36663182_rin
ripe66038922_ripe
rips66237432_rips
scrip96619192scrip
ship95228232ship
sip57656012_sip
skip105421742skip
slip67031732slip
snip66424652snip
sri35634002sri_
sris45434152sris
strip77524332strip
thrip103012182thrip
tip56551222_tip
trap67532802trap
trig55528162trig
trim65329512trim
trio45233342trio
tripe75425382tripe
trips74923362trips
trop66833302trop
unrip72012862unrip
uric63624932uric
urp56426392ur_p
whip125521842whip
wrap96821972wrap
writ75537912writ
yip87241172_yip
zip146636222_zip

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 Filter178691298720.1101624463.6
2DLD Change Limit298721781.22024485.2
3Display Results1781780.0602966.7
 (SQL Overall)1786911781.390128554.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.