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

122 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
kickups144350(None) 
kickup1354131kickup_
pickups1754251pickups
backups1736172backups
cockups1735222cockups
fuckups1832922fuckups
hiccups1643222hiccups
kickers124013292kickers
kicks104420082kick__s
linkups1333632linkups
lockups1534242lockups
mockups1733342mockups
pickup1655632pickup_
stickups1643302stickups
wickiups19181962wickiups
wickyups22171772wickyups
backup1646613backup_
biceps12447713bic_eps
bickers154316553bickers
checkups2142803checkups
cockup1635713cockup_
coups95522473__coups
crackups1843123crackups
cups85430823__c_ups
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
dickies143416343dickies
dicks125824693dick__s
dictums1235553dictums
dinkums1433673dinkums
fichus14388113fichu_s
ficus105015493fic_u_s
fuckup1733963fuckup_
hiccup1554393hiccup_
hickeys19508223hickeys
hickies163614743hickies
hicks145322173hick__s
hookups1633263hookups
ickers123914183_ickers
ictus7249703_ictu_s
keckles12318763keckles
kecks105416573keck__s
ketchups1941893ketchups
kick96026073kick___
kickbox2142543kickbox
kicked124415943kick_ed
kicker114116183kick_er
kickier12349053kickier
kickiest13319673kickiest
kicking133314023kicking
kickoff1843013kickoff
kickoffs1941743kickoffs
kicky135012333kick__y
kidnaps1453323kidnaps
kikes85122553ki_k_es
kingcups1742063kingcups
kinks84926083kink__s
kips106430523ki___ps
kirks84915263kirk__s
klicks11468723klick__s
knickers13306723knickers
lickers134118253lickers
licks115325393lick__s
lineups934913lineups
linkup1245123linkup_
lockup1434763lockup_
lookups1332953lookups
markups1534963markups
mickeys18447943mickeys
mickles153415003mickles
micks135525373mick__s
mixups1743263mi_xups
mockup1634073mockup_
nickels13338653nickels
nickers134415093nickers
nickles133713823nickles
nicks114920493nick__s
oilcups1143333oilcups
pickers153718093pickers
pickets154314183pickets
pickles153215443pickles
picks135226143pick__s
piculs103511753pic_uls
pileups11365433pileups
pinups1037413pi_nups
recoups1188843recoups
rickets134915093rickets
rickeys16548983rickeys
ricks115126133rick__s
rictus8379193rictu_s
ruckus12407793rucku_s
scaups105411933_scaups
scups95316653_sc_ups
sickees134514213sickees
sickens134411483sickens
sickies133717503sickies
sickles133417543sickles
sickos125112033sick_os
sickouts1455503sickouts
sicks115127623sick__s
sirups83710533si_rups
situps8538783si_tups
stackups1643313stackups
stickums1643943stickums
stickup1533853stickup_
tickers133617723tickers
tickets134113683tickets
tickles133416853tickles
ticks115823293tick__s
tittups933353tittups
walkups1633013walkups
wickape1843723wickape
wickapes1943703wickapes
wickers164114703wickers
wickets164010943wickets
wickiup18172673wickiup_
wicks144619363wick__s
wickyup21171883wickyup_
wikiups16132083wikiups
windups1334783windups
workups1633613workups

Search took 7 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 Limit1340271225.83022989.2
3Display Results1221220.0462652.2
 (SQL Overall)1786911226.28228444.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.