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

116 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
stickup153385(None) 
stackup1533741stackup
stickum1534821stickum
stickups1643301stickups
kickup1354132_kickup
pickup1655632_pickup
stackups1643312stackups
stick115121562stick__
sticked144114632sticked
sticker133515882sticker
stickful1743442stickful
stickit1339462stickit
stickle132410972stickle
stickout1476332stickout
sticks125118612stick_s
stickums1643942stickums
sticky154711342stick_y
stirrup943002stirrup
backup1646613_backup
checkup2043323checkup
cockup1635713_cockup
crackup1743563crackup
fuckup1733963_fuckup
hiccup1554393_hiccup
kickups1443503_kickups
linkup1245123_linkup
lockup1434763_lockup
mockup1634073_mockup
pickups1754253_pickups
scaup95515993s__caup
scup84822383s__c_up
shicker163914823shicker
shicksa1634103shicksa
shtick15308023shtick__
shticks16356963shtick_s
shticky19344473shtick_y
sick106435573s_ick__
sicked134524403s_icked
sickee124622223s_ickee
sicken124615253s_icken
sicker124023903s_icker
sickie123715743s_ickie
sickle124418323s_ickle
sickly153110483s_ickly
sicko115315393s_ick_o
sickos125112033s_ickos
sickout1359373s_ickout
sicks115127623s_ick_s
sirup74014913s_i_rup
situp74414063s_i_tup
slick115520523slick__
slicked144413843slicked
slicken13309293slicken
slicker133314533slicker
slickly1635853slickly
slicks124816113slick_s
slipup1034503sli_pup
snick114416013snick__
snicked143811633snicked
snicker133012673snicker
snicks124312473snick_s
spick134519073spick__
spicks144814993spick_s
stack114421693stack__
stacked143416123stacked
stacker134416263stacker
stacks124317263stack_s
standup1034353standup
startup934963startup
stibium1145843stibium
stich104117923stic__h
stichic1446243stichic
stichs114511653stic_hs
stickers142913033stickers
stickfuls1842583stickfuls
stickier14229763stickier
stickies142211973stickies
stickily1736083stickily
sticking153513463sticking
stickled15298973stickled
stickler14259573stickler
stickles142512103stickles
stickman1643943stickman
stickmen1634543stickmen
stickouts1553973stickouts
stickpin1643763stickpin
stink95122503stink__
stinkbug1541563stinkbug
stinker113313313stinker
stinko10499393stink_o
stinks105616833stink_s
stinky134611073stink_y
stirk95717413stirk__
stirks104914243stirk_s
stirp76815503sti__rp
stirrups1042603stirrups
stock114417563stock__
stocked144312873stocked
stocker133713083stocker
stocks124715633stock_s
stocky15369153stock_y
stoup75517073st__oup
strick124813203strick__
stricken1436893stricken
strickle1467793strickle
stricks134310693strick_s
stuck114515773stuck__
tick106231223_tick__
ticked134720523_ticked
ticker124321503_ticker
ticket124524853_ticket
tickle124616743_tickle
ticks115823293_tick_s
tittup834203_tittup
wickiup18172673_wickiup
wickyup21171883_wickyup

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.390458182.1
2DLD Change Limit1340271166.59320328.7
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.02925422.0
 
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.