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

109 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
slacker13391529(None) 
blacker154513511blacker
clacker153813771clacker
lacker125325621_lacker
sacker125124841s_acker
slacked143815451slacked
slacken13399931slacken
slackers143812741slackers
slaker104219271sla_ker
slicker133314531slicker
smacker153410581smacker
snacker133112601snacker
stacker134416261stacker
backer144525522_backer
blacked163613372blacked
blacken15439792blacken
blanker134612022blanker
blocker15419922blocker
clacked164113602clacked
clackers163911702clackers
clicker154111882clicker
clocker153910872clocker
cracker153114172cracker
dacker134920752_dacker
flacked173711582flacked
flackery20295242flackery
flaker134916172fla_ker
flanker143911292flanker
flicker163610622flicker
glacier103911302glacier
hacker154822692_hacker
jacker194417582_jacker
knacker12307912knacker
lacer75833752_lac_er
lacier84020092_lacier
lacked135324652_lacked
lackers134120542_lackers
lackey154813352_lackey
laker95432872_la_ker
lanker104123002_lanker
larker104519242_larker
licker125222042_licker
locker124019422_locker
packer144223402_packer
placer105117742plac_er
placket15412872placket
plucker15368242plucker
racker124824552_racker
sacked135525212s_acked
sackers133820222s_ackers
saker95132022s_a_ker
shacked174015392shacked
shackler17317972shackler
shaker134319462sha_ker
sharker144313812sharker
shicker163914822shicker
shocker163411432shocker
shucker163710102shucker
sicker124023902s_icker
skanker10268482skanker
slabber113311392slabber
slack115021762slack__
slackener1543932slackener
slackens14367712slackens
slackest14289402slackest
slackly1635262slackly
slacks124416532slack_s
slake93724052sla_ke_
slaked114318272sla_ked
slakers114115752sla_kers
slakes104021882sla_kes
slammer113913032slammer
slander84015442slander
slapper113512472slapper
slasher104515332slasher
slater64429182sla_ter
slather103816082slather
slatier74016812slatier
slaver94419612sla_ver
slayer93916332sla_yer
sleeker11339822sleeker
slicer84117602slic_er
slicked144413842slicked
slicken13309292slicken
slickers143112552slickers
smacked163710992smacked
smackers16318712smackers
snacked144013112snacked
snackers143010222snackers
snicker133012672snicker
soaker105717532soa_ker
solacer93011102solac_er
spacer104917792spac_er
spacier114011632spacier
spanker133612352spanker
sparker133914362sparker
stacked143416122stacked
stackers143413562stackers
stalker113912252stalker
starker114114692starker
sticker133515882sticker
stocker133713082stocker
sucker124120662s_ucker
swacked173110522swacked
swanker14369482swanker
tacker124224502_tacker
tracker133515172tracker
wacker154920122_wacker
whacker19368502whacker

Search took 9 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 Filter1786911076710.750238254.7
2DLD Change Limit1076711097.23614879.9
3Display Results1091090.0761434.2
 (SQL Overall)1786911098.06222164.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.