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

114 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
driver10471449(None) 
deriver114213911deriver
diver94827801d_iver
drier64423961dri_er
drive95318001drive_
drivel105110381drivel
driven105210141driven
drivers114412791drivers
drives105117111drives
drover104614591drover
river85731691_river
aiver85725162_aiver
arider74717742arider
arriver10117792arriver
braver114719042braver
briber104714052briber
brier74527402bri_er
briner84519042briner
codriver1435912codriver
craver114618472craver
crier74724462cri_er
daiker115113032daiker
deicer94114412deicer
deliver113312242deliver
delver104913492delver
depriver1446292depriver
derider93214972derider
derive103817042derive_
derived123912762derived
derivers123811362derivers
derives114017812derives
dicer85426422d_icer
diker105524552d_iker
dimer85625602d_imer
diner65632902d_iner
direr64927072d_irer
dive85634772d_ive_
dived106321372d_ived
divers105024962d_ivers
divert103922812d_ivert
dives95832402d_ives
drainer83012842drainer
draper94315692draper
drave95219272drave_
drawer104711362drawer
dried75321382dri_ed
driers74516732dri_ers
dries64733672dri_es
drifter11348702drifter
driller84311882driller
drinker12349482drinker
dripper12349232dripper
driveler1284692driveler
drivels11397922drivels
droner74717672droner
drove95518062drove_
droved114611642droved
drovers115212642drovers
droves105116672droves
dryer95111462dr_yer
duiker114110592duiker
fiver116024942_fiver
frier85225842fri_er
frizer184011282frizer
giver94921202_giver
graver105018592graver
griever1136032griever
griper94114612griper
grivet103517822grivet
jiver155119052_jiver
liver85132962_liver
naiver94311352naiver
pricer103918292pricer
prier75027762pri_er
primer105118682primer
privet113821342privet
privier122910452privier
prizer174714882prizer
prover113819722prover
quiver18278742quiver
raver85631492_raver
reiver95318292reiver
ricer74726612_ricer
rider65231302_rider
riever94811652_riever
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
rive75537722_rive_
rived94825612_rived
riven85121622_riven
rivers94626542_rivers
rives85336002_rives
rivet85636362_rivet
rover85527372_rover
shiver124517372shiver
shriver134712192shriver
siver85728612_siver
skiver134612102skiver
sliver94116592sliver
stiver93915732stiver
striver104315202striver
thriver13479122thriver
trier54328532tri_er
trimer85717152trimer
triter65120592triter
trivet93721882trivet
trover95014662trover
upriver12196932upriver
waiver124212712waiver
wiver115924512_wiver
wrier84521752wri_er
writer94416512writer

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 Filter178691825510.343520965.0
2DLD Change Limit825511142.29635954.3
3Display Results1141140.0303800.0
 (SQL Overall)1786911142.66966950.5
 
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.