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

160 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
drip7622395(None) 
dip67848981d_ip
drib76823261drib
drips85417231drips
dript86923871dript
drop75324401drop
grip76127021grip
rip56851301_rip
trip66830391trip
aria46245422aria
arid57642712arid
aril45843022aril
atrip75315752atrip
blip88322772blip
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
chip116726422chip
clip86924002clip
crap85731842crap
crib86323582crib
crimp115615802crimp
cripe95521142cripe
cris66233432cris
crisp95014622crisp
crit65743712crit
crop87628632crop
dais57040702dais
damp96228842damp
dap66652452d_ap
daric85623112daric
deep76031882deep
deil56231622deil
dib65746942d_ib
did56850522d_id
die46759652d_ie
dif76846902d_if
dig57544472d_ig
dim68146492d_im
din46459462d_in
dips75536912d_ips
dipt77339322d_ipt
dire56644142dire
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
dis46459892d_is
dit47071332d_it
djin12911632djin
doit56347852doit
dorp76028052dorp
drab76226452drab
drag64825052drag
drail65020972drail
drain65222892drain
dram75832002dram
drape85319632drape
drat56247832drat
draw85623012draw
dray85428092dray
dree56638322dree
dreg66821652dreg
drek96321092drek
drew86221672drew
dribs85115062dribs
dried75321382dried
drier64423962drier
dries64733672dries
drift95722842drift
drill64718262drill
drily95816522drily
drink106816382drink
drippy14445652drippy
drive95318002drive
droid74218542droid
droit65127122droit
droop85814822droop
drops85719502drops
dropt86924432dropt
drub75920132drub
drug65718132drug
druid74111322druid
drum76521592drum
drupe85012992drupe
dry76526032dr_y
drys86314802drys
dui46433382dui_
duit56241582duit
dump95927092dump
dup67637882d_up
flip96324262flip
frap95925812frap
frig85424502frig
frit77044472frit
friz166324342friz
gip67645362_gip
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
gripe84622962gripe
grips85520132grips
gript85126172gript
gripy115115252gripy
grit55247242grit
hip86750432_hip
irid55927172irid
iris45732552iris
kip97042142_kip
kris86423602kris
lip514755802_lip
nip56945982_nip
pip78051042_pip
prep86427672prep
prig75924872prig
prim85132202prim
primp115615922primp
prop85932812prop
quip154818622quip
rap56261962_rap
rep55847802_rep
ria36745502_ria
rib56848032_rib
rid46754632_rid
rif65951562_rif
rig46748122_rig
rim56052272_rim
rin36663182_rin
ripe66038922_ripe
rips66237432_rips
scrip96619192scrip
ship95228242ship
sip57656012_sip
skip105421752skip
slip67031732slip
snip66424652snip
sri35634002sri_
sris45434152sris
strip77524342strip
thrip103012182thrip
tip56551222_tip
trap67532802trap
trig55528162trig
trim65329522trim
trio45233342trio
tripe75425382tripe
trips74923362trips
trop66833302trop
unrip72012862unrip
uric63624942uric
urp56426402ur_p
whip125521842whip
wrap96821972wrap
writ75537912writ
yip87241182_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.283631417.0
2DLD Change Limit298721600.86034734.9
3Display Results1601600.0463478.3
 (SQL Overall)1786911601.189150286.8
 
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.