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

90 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
stickups164330(None) 
stackups1643311stackups
stickums1643941stickums
stickup1533851stickup_
kickups1443502_kickups
pickups1754252_pickups
stackup1533742stackup_
stickers142913032stickers
stickfuls1842582stickfuls
stickies142211972stickies
stickles142512102stickles
stickouts1553972stickouts
sticks125118612stick__s
stickum1534822sticku_m
stirrups1042602stirrups
backups1736173_backups
checkups2142803checkups
cockups1735223_cockups
crackups1843123crackups
fuckups1832923_fuckups
hiccups1643223_hiccups
kickup1354133_kickup_
linkups1333633_linkups
lockups1534243_lockups
mockups1733343_mockups
pickup1655633_pickup_
scaups105411933s__caups
scups95316653s__c_ups
shickers173012823shickers
shicksas1743523shicksas
shticks16356963shtick__s
sickees134514213s_ickees
sickens134411483s_ickens
sickies133717503s_ickies
sickles133417543s_ickles
sickos125112033s_ick_os
sickouts1455503s_ickouts
sicks115127623s_ick__s
sirups83710533s_i_rups
situps8538783s_i_tups
slickens14317263slickens
slickers143112553slickers
slicks124816113slick__s
slipups1133193sli_pups
snickers143010963snickers
snicks124312473snick__s
spicks144814993spick__s
stackers143413563stackers
stacks124317263stack__s
standups1143963standups
startups1033893startups
stibiums1244203stibiums
stichs114511653stic__hs
stick115121563stick___
sticked144114633stick_ed
sticker133515883stick_er
stickful1743443stickful
stickier14229763stickier
stickiest15229603stickiest
stickily1736083stickily
sticking153513463sticking
stickit1339463stick_it
stickle132410973stick_le
stickled15298973stickled
stickler14259573stickler
sticklers15227393sticklers
stickman1643943stickman
stickmen1634543stickmen
stickout1476333stickout
stickpin1643763stickpin
stickpins1744093stickpins
sticky154711343stick__y
stinkbugs1641443stinkbugs
stinkers123111133stinkers
stinks105616833stink__s
stirks104914243stirk__s
stirps85011823sti__rps
stirrup943003stirrup_
stockers143411073stockers
stocks124715633stock__s
stoups85313273st__oups
strickles1567813strickles
stricks134310693strick__s
tickers133617723_tickers
tickets134113683_tickets
tickles133416853_tickles
ticks115823293_tick__s
tittups933353_tittups
wickiups19181963_wickiups
wickyups22171773_wickyups

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 Filter1786911461620.423422437.4
2DLD Change Limit146162907.87618557.9
3Display Results90900.0303000.0
 (SQL Overall)178691908.32921454.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.