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

139 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
docker13441765(None) 
cocker144320391cocker
dacker134920751dacker
decker135215991decker
dicker134521401dicker
docked145018331docked
dockers143715001dockers
docket134721171docket
ducker134317991ducker
hocker155118561hocker
locker124019421locker
mocker143315441mocker
ocker113915751_ocker
rocker124319571rocker
backer144525522backer
bicker144819172bicker
blocker15419922blocker
booker124719192booker
bosker123813652bosker
bucker145420462bucker
clocker153910872clocker
cocked155022562cocked
cockers153618332cockers
cockier154013622cockier
conker124721552conker
cooker124722452cooker
corker124720852corker
dackers143417042dackers
daiker115113032daiker
danker114319662danker
darker114718692darker
decked145217622decked
deckel134911042deckel
deckers144413832deckers
dicer85426422dic_er
dicier94416232dicier
dicked144920862dicked
dickers144117662dickers
dickey165913522dickey
dickier143512452dickier
diker105524552d_iker
dobber114015412dobber
dock116228742dock__
dockets144412242dockets
docks126022312dock_s
doctor938992doctor
dodder94712912dodder
dodger95817042dodger
doer57734702do__er
doffer133911352doffer
dogger95216782dogger
donkey14449732donkey
doozer163910462doozer
doper86128392do_per
dopier93515922dopier
dorkier122810022dorkier
dormer94415892dormer
dorper94314562dorper
dorser74819172dorser
doser66228562do_ser
dosser74417972dosser
doter65428622do_ter
dotier73917032dotier
dotter74419342dotter
dourer74215272dourer
douser75621632douser
dower95027702do_wer
downer104414922downer
dowser104716082dowser
dozer158419272do_zer
dozier163611632dozier
ducked144718012ducked
duckers143214712duckers
duckier143911792duckier
duiker114110592duiker
dunker113616462dunker
forker134717902forker
fucker153414422fucker
hacker154822692hacker
hocked165521302hocked
hockers163915912hockers
hockey184813152hockey
honker134117462honker
hooker134820172hooker
icker114018442_icker
jacker194417582jacker
jockey22408032jockey
joker165715892jo_ker
kicker114116182kicker
knocker12296392knocker
lacker125325622lacker
licker125222042licker
locked134921662locked
lockers133516922lockers
locket123922472locket
looker104816952looker
mocked154716612mocked
mockers153812942mockers
mockery18376912mockery
mucker143816392mucker
necker124012792necker
nicker123818702nicker
nocked134617382nocked
ocher104516102_ocher
ockers123813902_ockers
packer144223402packer
pecker144615362pecker
picker144422172picker
pocked154818982pocked
pocket144622622pocket
pockier153911602pockier
poker115122882po_ker
porker124917542porker
pucker143817632pucker
racker124824552racker
rocked135022322rocked
rockers133916552rockers
rockery16439252rockery
rocket125425282rocket
rockier134911882rockier
sacker125124842sacker
shocker163411422shocker
sicker124023902sicker
soaker105717532soaker
soccer1038542soccer
socked134721502socked
socket123923522socket
stocker133713082stocker
sucker124120662sucker
tacker124224502tacker
ticker124321502ticker
tocher114014912tocher
toker95924912to_ker
tucker124316952tucker
wacker154920122wacker
wicker154518672wicker
worker134715112worker
yocked164114422yocked
yonker134110852yonker

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.1401276364.3
2DLD Change Limit825511392.56332208.7
3Display Results1391390.0463021.7
 (SQL Overall)1786911392.74965002.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.