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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
stackups164331(None) 
stackup1533741stackup_
stickups1643301stickups
backups1736172_backups
crackups1843122crackups
stackers143413562stackers
stacks124317262stack__s
standups1143962standups
startups1033892startups
stickums1643942stickums
stickup1533852stickup_
backup1646613_backup_
catchups1744383catchups
checkups2142803checkups
cockups1735223_cockups
crackup1743563crackup_
fuckups1832923_fuckups
kickups1443503_kickups
lockups1534243_lockups
markups1534963_markups
matchups1743073matchups
mockups1733343_mockups
pickups1754253_pickups
sacbuts1166473s_acbuts
sackbuts1644053s_ackbuts
sackers133820223s_ackers
sackfuls1744163s_ackfuls
sacks114228873s_ack__s
sacques18106863s_acques
sacrums11388043s_acrums
sannups934463s_annups
scaleups1243393scaleups
scaups105411933s__caups
scups95316653s__c_ups
shackles173010593shackles
shackoes17367853shackoes
shackos16429023shack_os
shacks154817563shack__s
shakeups1742373shakeups
shapeups1542723shapeups
slackens14367713slackens
slackers143812743slackers
slacks124416533slack__s
smackers16318713smackers
smacks144112323smack__s
smashups1543213smashups
snackers143010223snackers
snacks124514553snack__s
spackles16319953spackles
stack114421693stack___
stacked143416123stack_ed
stacker134416263stack_er
stacking154215083stacking
stackless1555933stackless
stactes91914633stac_tes
stadiums1145703stadiums
stakes103927293sta_k_es
stalkers12369853stalkers
stalks104614553stalk__s
stamps105614023sta__mps
standup1034353standup_
stanks104917703stank__s
stannums1043803stannums
starkers123712393starkers
startup934963startup_
statues74614903sta_tues
status65515213sta_tu_s
stickers142913033stickers
stickfuls1842583stickfuls
stickies142211973stickies
stickles142512103stickles
stickouts1553973stickouts
sticks125118613stick__s
stickum1534823sticku_m
stirrups1042603stirrups
stockers143411073stockers
stocks124715633stock__s
stoups85313273st__oups
tackers134319623_tackers
tackets134914363_tackets
tackles133816523_tackles
tacks115430133_tack__s
takeups1333403_takeups
teacups1133963teac_ups
walkups1633013_walkups

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 Filter1786911461620.530337152.8
2DLD Change Limit146162856.78321548.3
3Display Results85850.0302833.3
 (SQL Overall)178691857.34324334.9
 
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.