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

162 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
dross6541809(None) 
cross75124501cross
doss56235041d_oss
dress65319831dress
drops85719501drops
drossy10528471drossy
gross65421691gross
pross76529401pross
across8312642across
arose55832082arose
boss65938342_boss
brass75428022brass
briss75824272briss
broos75126412broos
bros65635662bro_s
brose75227032brose
broses86524402broses
brosy106115382brosy
brows105425982brows
coss66143492_coss
crass76328042crass
cress75022832cress
crocs95722432crocs
crops96125232crops
crosse85216302crosse
crows105727312crows
dhows125911222dhows
diols65521012diols
diss56434482d_iss
docs75631152d_ocs
does56554472d_oes
dogs66440152d_ogs
dols56943052d_ols
doms76239572d_oms
dons56048702d_ons
dooms85321342dooms
doors65022132doors
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602d_ors
dorsa64617282dorsa
dos48062312d_o_s
dose56442432d_ose
doses65938502d_oses
dost57248352d_ost
dots55647662d_ots
dows85941052d_ows
drabs85119672drabs
drags75521112drags
drams86025832drams
drats66628372drats
draws95119372draws
drays95819772drays
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dressy10518142dressy
drest65530342drest
dribs85115062dribs
dries64733672dries
drips85417232drips
droid74218542droid
droids84712582droids
droit65127122droit
droits74314312droits
droll65415402droll
drolls75312392drolls
drone65324982drone
drones75023432drones
drool65416102drool
drools74412812drools
droop85814822droop
droops95110962droops
drop75324402dro_p
dropsy12497472dropsy
dropt86924432dropt
drosky14486162drosky
drosses84513822drosses
drouk1039432drouk
drouks1137122drouks
drove95518062drove
droves105116672droves
drown95515822drown
drowns105612332drowns
drowse105010552drowse
drowses114610232drowses
drowsy13487902drowsy
drubs85913832drubs
drugs75214652drugs
drums85415872drums
druse64817662druse
druses75517252druses
drys86314802dr_ys
duos56728132duo_s
duress74712062duress
durocs9569702durocs
duros65422692duro_s
eros45238452ero_s
erose55727272erose
eroses65327052eroses
floss85118262floss
foss76431642_foss
frass85321122frass
froes86126692froes
frogs96220772frogs
frons86124042frons
frosh115713402frosh
frost84727832frost
frosts94214622frosts
frows116623102frows
gloss64319622gloss
grass66125202grass
grogs76319412grogs
groks105716122groks
grosz154814092grosz
grots65025852grots
grows95523922grows
irons55324132irons
joss115925592_joss
kaross101910012kaross
koss85224812_koss
loss45337962_loss
moss67641032_moss
press75425952press
priss74623892priss
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782pro_s
prose75835122prose
proses84733472proses
proso77222412proso
prosos85718552prosos
prost75434102prost
prosy106319252prosy
prows106327012prows
robs65837872_robs
rocs65533662_rocs
rods56442062_rods
roes45954142_roes
roms67038962_roms
rose46148902_rose
roses56445772_roses
rosy76024872_rosy
rots46454092_rots
rows75941752_rows
stoss54316342stoss
toss45637972_toss
trass56226472trass
tress55423162tress
trogs67022602trogs
trois57226092trois
trots56629942trots
trows88826182trows
troys86418612troys
truss54916922truss
vrows116115262vrows

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 Filter178691538000.310576422.6
2DLD Change Limit538001621.36039558.8
3Display Results1621620.0503240.0
 (SQL Overall)1786911621.720103890.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.