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

154 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
ticketed1514664(None) 
picketed17167381picketed
thicketed1943611thicketed
bickered17108002bickered
bucketed1736762bucketed
cricketed1854692cricketed
dickered16117532dickered
docketed16156582docketed
jacketed22146532jacketed
nickeled15115512nickeled
nickered15117022nickered
packeted17148282packeted
picketer16187432picketer
pocketed17147142pocketed
racketed15169122racketed
rocketed15157792rocketed
sickened1546782sickened
socketed15177342socketed
thickened1944302thickened
ticked134720522tick__ed
ticket124524852ticket__
tickets134113682ticket_s
tickled144313132tick_led
tickseed1584512tickseed
tinkered1387682tinkered
trinketed1444252trinketed
tuckered1535962tuckered
accreted1336333accreted
bickerer16106783bickerer
billeted1137643billeted
bracketed1855863bracketed
cacheted16148233cacheted
casketed1534953casketed
chickened2144623chickened
cockered17710213cockered
cockeyed2096123cockeyed
cricketer1744573cricketer
crocketed1845123crocketed
dackered16116893dackered
dicked144920863dick__ed
dictated1239203dictated
dieted83115493di__eted
excreted1846153excreted
faceted13509563fac_eted
fidgeted1443893fidgeted
fileted1159093fi_leted
filleted1236603filleted
flickered1943753flickered
gibbeted1492783gibbeted
gimleted1243973gimleted
isleted837523_isleted
jockeyed2563413jockeyed
junketed2033523junketed
kicked124415943kick__ed
lackered15108683lackered
lackeyed18104513lackeyed
lichened1435753lichened
lichted13268803lic_hted
licked134621563lick__ed
likened12267353li_kened
marketed1537323marketed
nicked135019683nick__ed
nickelled1653793nickelled
nickled144010443nick_led
nictated1137793nictated
pickaxed2443513pickaxed
picked154421313pick__ed
pickeer153710113picke_er
pickeered1843463pickeered
pickerel1645273pickerel
picket144924313picket__
picketers17196483picketers
pickets154314183picket_s
pickled164011883pick_led
picoted1239213pic_oted
picrated132110113picrated
pinkened1535753pinkened
pocketer16157373pocketer
puckered1736103puckered
quickened2543163quickened
racheted14149503racheted
richened1435953richened
ricked136523623rick__ed
ricketier15134583ricketier
rickets134915093ricket_s
rickety16478313ricket_y
riveted11258573ri_veted
rocketer14158333rocketer
sacheted14127833sacheted
secreted1138643secreted
shickered19115723shickered
sickbed16396823sick_bed
sicked134524403sick__ed
sickee124622223sicke_e_
sickees134514213sicke_es
sickener1436603sickener
sickled144713433sick_led
sicklied1546583sicklied
signeted1035973signeted
slickened1644293slickened
snickered16115343snickered
sticked144114633stick__ed
stickled15298973stick_led
stickseed1683483stickseed
stickweed1983383stickweed
suckered1537833suckered
tableted1137533tableted
tacked134723943tack__ed
tacket124627493tacket__
tackets134914363tacket_s
tackled143913193tack_led
targeted1037483targeted
telneted935073telneted
thickener1844163thickener
thicket163213073thicket__
thickets17287083thicket_s
thickety20274103thicket_y
ticced11438443tic__ced
ticker124321503tick__er
tickers133617723ticke_rs
ticketing1635633ticketing
ticketless1641933ticketless
tickle124616743tick_le_
tickler133612653tick_ler
tickles133416853tick_les
tickseeds1673233tickseeds
tiered73613973ti__ered
tillered937443tillered
tilted74616863ti__lted
timbered13137383timbered
tincted1037273ti_ncted
tinkerer1286803tinkerer
tinkled123910473tink_led
tinseled935763tinseled
tinted74419533ti__nted
titrated92611683titrated
tittered9239493tittered
tochered1437913tochered
toileted936993toileted
tokened1236393t_okened
tricked144016163trick__ed
trickled152610433trick_led
trickster15265713trickster
trinketer1344563trinketer
tucked134017493tuck__ed
tucket124219483tucket__
tuckets134810333tucket_s
turreted935373turreted
tweeted11336583t_weeted
whickered22114033whickered
wicked164317413wick__ed
wickeder1843983wickeder
wicket155318943wicket__
wickets164010943wicket_s

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.420425454.8
2DLD Change Limit1461621547.06320694.0
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.54623680.2
 
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.