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

132 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
drib7682326(None) 
crib86323581crib
dib65746941d_ib
drab76226451drab
dribs85115061dribs
drip76223951drip
drub75920131drub
rib56848031_rib
arb510448422ar_b
aria46245422aria
arid57642712arid
aril45843022aril
bib77045942_bib
bribe94820782bribe
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
crab85727672crab
cribs94516752cribs
cris66233432cris
crit65743712crit
dab67455562d_ab
dais57040702dais
darb76033532darb
daric85623112daric
daub77423442daub
deb66342692d_eb
deil56231622deil
dibs76233682d_ibs
did56850512d_id
die46759652d_ie
dif76846902d_if
dig57544472d_ig
dim68146492d_im
din46459462d_in
dip67848982d_ip
dire56644142dire
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
dis46459892d_is
dit47071332d_it
djin12911632djin
doit56347852doit
drabs85119672drabs
drag64825052drag
drail65020972drail
drain65222892drain
dram75832002dram
drat56247832drat
draw85623012draw
dray85428092dray
dree56638322dree
dreg66821652dreg
drek96321092drek
drew86221672drew
dried75321382dried
drier64423962drier
dries64733672dries
drift95722842drift
drill64718262drill
drily95816522drily
drink106816382drink
drips85417232drips
dript86923872dript
drive95318002drive
droid74218542droid
droit65127122droit
drop75324402drop
drubs85913832drubs
drug65718132drug
druid74111322druid
drum76521592drum
dry76526032dr_y
drys86314802drys
dub66642202d_ub
dui46433382dui_
duit56241582duit
dumb97124102dumb
fib86344272_fib
frig85424502frig
frit77044472frit
friz166324342friz
gib66443532_gib
glib79421442glib
grab75427612grab
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
grip76127022grip
grit55247242grit
grub77220082grub
irid55927172irid
iris45732552iris
jib125835972_jib
kris86423602kris
lib57750272_lib
mib76946122_mib
midrib1138242midrib
nib56745192_nib
orb55736862or_b
oribi7311092oribi
prig75924872prig
prim85132202prim
reb55844962_reb
ria36745502_ria
ribs65833022_ribs
rid46754622_rid
rif65951562_rif
rig46748122_rig
rim56052272_rim
rin36663182_rin
rip56851302_rip
rob56754302_rob
rub56342822_rub
sib56850312_sib
snib66522982snib
sri35634002sri_
sris45434152sris
tribe74420272tribe
trig55528162trig
trim65329522trim
trio45233342trio
trip66830392trip
urb55731102ur_b
uric63624932uric
writ75537912writ

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.0632836365.1
2DLD Change Limit298721320.87334217.6
3Display Results1321320.0168250.0
 (SQL Overall)1786911320.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.