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 “stackup” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
stackup153374(None) 
stackups1643311stackups
stickup1533851stickup
backup1646612_backup
crackup1743562crackup
stack114421692stack__
stacked143416122stacked
stacker134416262stacker
stacks124317262stack_s
standup1034352standup
startup934962startup
stickum1534822stickum
stickups1643302stickups
backups1736173_backups
catchup1644793catchup
checkup2043323checkup
cockup1635713_cockup
crackups1843123crackups
faceup1334893_faceup
fuckup1733963_fuckup
kickup1354133_kickup
lockup1434763_lockup
markup1436903_markup
matchup1643513matchup
mockup1634073_mockup
pickup1655633_pickup
sacbut10811943s_acbut
sack105337313s_ack__
sackbut1545943s_ackbut
sacked135525213s_acked
sacker125124843s_acker
sackful1645353s_ackful
sacks114228873s_ack_s
sacque17107113s_acque
sacrum103910143s_acrum
sannup836563s_annup
scaleup1134483scaleup
scaup95515993s__caup
scup84822383s__c_up
shack145321753shack__
shacked174015393shacked
shackle16409543shackle
shacko153810113shack_o
shackos16429023shackos
shacks154817563shack_s
shakeup1632763shakeup
shapeup1443293shapeup
slack115021763slack__
slacked143815453slacked
slacken13399933slacken
slacker133915293slacker
slackly1635263slackly
slacks124416533slack_s
smack134615453smack__
smacked163710993smacked
smacker153410583smacker
smacks144112323smack_s
smashup1443453smashup
snack114718063snack__
snacked144013113snacked
snacker133112603snacker
snacks124514553snack_s
spackle15369573spackle
stackers143413563stackers
stacking154215083stacking
stacte82113913stac_te
stactes91914633stactes
stadium1038073stadium
stake95927533sta_k_e
staked114621943sta_ked
stakes103927293sta_kes
stalk94518003stalk__
stalked123811173stalked
stalker113912253stalker
stalks104614553stalk_s
stalky13499303stalk_y
stamp95217363sta__mp
standups1143963standups
stank95823303stank__
stanks104917703stank_s
stannum944643stannum
stark95425623stark__
starker114114693starker
starkly14277033starkly
startups1033893startups
statue66015323sta_tue
status65515213sta_tus
stick115121563stick__
sticked144114633sticked
sticker133515883sticker
stickful1743443stickful
stickit1339463stickit
stickle132410973stickle
stickout1476333stickout
sticks125118613stick_s
stickums1643943stickums
sticky154711343stick_y
stirrup943003stirrup
stock114417563stock__
stocked144312873stocked
stocker133713083stocker
stocks124715633stock_s
stocky15369153stock_y
stoup75517073st__oup
stuck114515773stuck__
swacked173110523swacked
tack106536293_tack__
tacked134723943_tacked
tacker124224503_tacker
tacket124627493_tacket
tackey154613083_tackey
tackle123815733_tackle
tacks115430133_tack_s
tacky145617443_tack_y
takeup1234583_takeup
teacup1036253teac_up
walkup1534193_walkup

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271177.34318252.3
3Display Results1171170.0333545.5
 (SQL Overall)1786911177.78222962.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.