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

142 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
dribs8511506(None) 
cribs94516751cribs
dibs76233681d_ibs
drabs85119671drabs
drib76823261drib_
dries64733671dries
drips85417231drips
drubs85913831drubs
ribs65833021_ribs
arbs66834732ar_bs
arias55438022arias
arils58732202arils
bibs84830992_bibs
bribe94820782bribe
bribes105918532bribes
bries74942152bries
brigs85823222brigs
brims94721622brims
brins75533972brins
brios74725722brios
bris65539612bri_s
briss75824272briss
brits76433082brits
crabs95421392crabs
crib86323582crib_
cries75438402cries
cris66233432cri_s
crits75527572crits
dabs77139402d_abs
dais57040702dai_s
darbs85323262darbs
darics94314112darics
daubs85014562daubs
debs76530242d_ebs
deils65722862deils
dib65746942d_ib_
dies55653522d_ies
difs86027322d_ifs
digs66036052d_igs
dims75435022d_ims
dins56652042d_ins
dips75536912d_ips
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
dis46459892d_i_s
diss56434482d_iss
dits56450522d_its
djins1368452djins
doits66223672doits
dories75232362dories
drab76226452drab_
drags75521112drags
drails74716952drails
drains73719402drains
drams86025832drams
drats66628372drats
draws95119372draws
drays95819772drays
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
dried75321382dried
drier64423962drier
driers74516732driers
driest74722752driest
drift95722842drift
drifts10499892drifts
drill64718262drill
drills74414202drills
drily95816522drily
drink106816382drink
drinks116810712drinks
drip76223952dri_p
dript86923872dript
drive95318002drive
drives105117112drives
droids84712582droids
droits74314312droits
drops85719502drops
dross65418092dross
drub75920132drub_
drugs75214652drugs
druids8368092druids
drums85415872drums
drys86314802dr_ys
dubs78432192d_ubs
duits65021882duits
dumbs105915752dumbs
fibs96329502_fibs
fries85535602fries
frigs96019272frigs
frits86129102frits
gibs75529272_gibs
grabs85719692grabs
grids75321392grids
grigs75318192grigs
grins65427222grins
grips85520132grips
grits65529582grits
grubs86312602grubs
irids66417772irids
iris45732552iri_s
jibs136724082_jibs
kris86423602kri_s
libs66732762_libs
mibs85330482_mibs
midribs1235512midribs
nibs65028312_nibs
orbs66626252or_bs
oribi7311092oribi
oribis838832oribis
pries74339532pries
prigs85219702prigs
prims95425932prims
priss74623892priss
rebs65733562_rebs
rias45540592_rias
rib56848032_rib_
ribes75530172_ribes
rids56539552_rids
rifs74929002_rifs
rigs55137592_rigs
rims65936302_rims
rins46153192_rins
rips66237432_rips
robs65837872_robs
rubs66133492_rubs
sibs65933542_sibs
snibs75613762snibs
sris45434152sri_s
tribe74420272tribe
tribes85119022tribes
tries55742812tries
trigs65423062trigs
trims75021472trims
trios55528092trios
trips74923362trips
urbs65922062ur_bs
wries85827742wries
writs86624382writs

Search took 3 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.343520965.0
2DLD Change Limit538001421.67032215.6
3Display Results1421420.0502840.0
 (SQL Overall)1786911422.06386617.1
 
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.