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

461 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
tickets13411368(None) 
pickets154314181pickets
rickets134915091rickets
tackets134914361tackets
thickets17287081thickets
tickers133617721tickers
ticket124524851ticket_
tuckets134810331tuckets
wickets164010941wickets
beckets15399822beckets
bickers154316552bickers
buckets153811692buckets
crickets16418122crickets
dickens144410132dickens
dickers144117662dickers
dickeys17479302dickeys
dockets144412242dockets
hickeys19508222hickeys
ickers123914182_ickers
jackets205011372jackets
kickers124013292kickers
lickers134118252lickers
lockets134612202lockets
mickeys18447942mickeys
nickels13338652nickels
nickers134415092nickers
packets155114772packets
pickers153718092pickers
picket144924312picket_
pockets154612252pockets
prickets16329082prickets
rackets134916872rackets
rickety16478312rickety
rickeys16548982rickeys
rockets134615362rockets
sickees134514212sickees
sickens134411482sickens
sickest131813792sickest
sockets134012982sockets
stickers142913032stickers
tackers134319622tackers
tacket124627492tacket_
thickens17266412thickens
thickest17337302thickest
thicket163213072thicket_
thickety20274102thickety
thicksets18263732thicksets
ticked134720522ticke_d
ticker124321502ticke_r
ticketed15146642ticketed
ticklers14339302ticklers
tickles133416852tickles
ticks115823292tick__s
tikes95628902ti_ke_s
tinkers113517142tinkers
tippets11339372tippets
trickers143812812trickers
trinkets1237142trinkets
tuckers134014352tuckers
tucket124219482tucket_
wickers164114702wickers
wicket155318942wicket_
ackees124914583_ackees
aiglets84012913aiglets
aigrets82810533aigrets
backers153821883backers
backsets1638853backsets
baskets135111833baskets
becket144619883becket_
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bidets95215533bi_dets
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
billets94516153billets
boskets13409473boskets
brackets163310433brackets
briskets14346563briskets
brockets16328123brockets
buckers153517453buckers
bucket144620733bucket_
cachets145014263cachets
caskets133910173caskets
chickees19258513chickees
chickens19267433chickens
circlets1235663circlets
civets115212543ci_vets
clickers163910203clickers
cockers153618333cockers
cricket154716953cricket_
crockets16339543crockets
dackers143417043dackers
deckels14367363deckels
deckers144413833deckers
detickers1634423detickers
dicasts1078703dicasts
dicers94720743dic_ers
dices86434243dic_e_s
diciest103316523diciest
dicked144920863dicke_d
dicker134521403dicke_r
dickey165913523dicke_y
dickies143416343dickies
dickiest153412503dickiest
dicks125824693dick__s
dicots94915793dic_ots
diets66026643di__ets
dikers114418793di_kers
dikes105831333di_ke_s
dinkeys15507263dinkeys
dipnets10109033dipnets
dockers143715003dockers
docket134721173docket_
duckers143214713duckers
facets116316653fac_ets
fices106031163fic_e_s
fiches145219533fiche_s
ficklest17267903ficklest
ficoes114613463ficoe_s
fidgets12388763fidgets
filets94718953fi_lets
fillets103414753fillets
fitchets16307413fitchets
flickers17338883flickers
friskets15326263friskets
fuckers163611593fuckers
gaskets12348153gaskets
gibbets12417723gibbets
giblets103210423giblets
giglets93211553giglets
gimlets10338433gimlets
hackees165014103hackees
hackers164619043hackers
hickey185011993hicke_y
hickies163614743hickies
hicks145322173hick__s
hikers135014353hi_kers
hikes125426983hi_ke_s
hockers163915913hockers
hockeys19509273hockeys
ices66129643_ic_e_s
iciest82914743_iciest
icker114018443_icke_r
ickiest133611043_ickiest
ikats95311153_i_kats
inkers104018833_inkers
inlets63915573_inlets
insets64016133_insets
islets64513083_islets
itches114916213itche_s
jackers204214453jackers
jacket194720673jacket_
jinkers183511813jinkers
jockeys23365953jockeys
junkets18377623junkets
kicked124415943kicke_d
kicker114116183kicke_r
kickiest13319673kickiest
kicks104420083kick__s
kickups1443503kickups
kikes85122553ki_ke_s
kismets13306883kismets
knickers13306723knickers
lackers134120543lackers
lackeys16458263lackeys
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
lichts113712383lic_hts
licked134621563licke_d
licker125222043licke_r
licks115325393lick__s
likens105613703li_kens
likers104620913li_kers
likes96231903li_ke_s
likest104914383li_kest
limpets11329783limpets
linkers114317713linkers
linnets739833linnets
lockers133516923lockers
locket123922473locket_
locksets1435693locksets
markets133314033markets
miches134320733miche_s
mickey174211853micke_y
mickles153415003mickles
micklest16219123micklest
micks135525373mick__s
midgets113910253midgets
mikes115129893mi_ke_s
milkers134411613milkers
millets94216843millets
minkes124618783minke_s
minuets9259853minuets
mirkest13309723mirkest
missets94516573missets
mockers153812943mockers
muckers153612803muckers
muskets13258643muskets
neckers134210463neckers
nicest82315663nic_est
nicety1138433nic_ety
niches114419143niche_s
nicked135019683nicke_d
nickel123811343nicke_l
nicker123818703nicke_r
nickles133713823nickles
nicks114920493nick__s
nidgets9358143nidgets
ockers123813903_ockers
octets839403_octets
packers153818893packers
packet144726503packet_
peckers153312673peckers
picked154421313picke_d
pickeer153710113pickeer
pickeers16347243pickeers
picker144422173picke_r
picketed17167383picketed
picketer16187433picketer
picketers17196483picketers
pickiest162712593pickiest
pickles153215443pickles
picks135226143pick__s
pickups1754253pickups
picots104616443pic_ots
picquets2143733picquets
piglets103311793piglets
pikers124717393pi_kers
pikes115031033pi_ke_s
pinkens13419643pinkens
pinkers134118603pinkers
pinkest132812623pinkest
pinkeys16378213pinkeys
piolets93513193piolets
pipets105714773pi_pets
piquets1836603piquets
plackets1646583plackets
pocket144622623pocket_
prickers163710673prickers
pricket153616443pricket_
puckers153514673puckers
quickens2334253quickens
quickest2345343quickest
quicksets2442383quicksets
rachets124516833rachets
rackers134320453rackers
racket125229423racket_
rackety16499113rackety
riblets93412553riblets
ricers84120993ric_ers
rices75536153ric_e_s
richens12349733richens
riches115022083riche_s
richest122813683richest
ricked136523623ricke_d
rickey154613973ricke_y
ricks115126133rick__s
rillets74216153rillets
riskers114011993riskers
rivets94417113ri_vets
rochets124213473rochets
rockers133916553rockers
rocket125425283rocket_
sachets123914103sachets
sackers133820223sackers
secrets9311773secrets
shickers173012823shickers
sices75637273sic_e_s
sickbeds17254213sickbeds
sicked134524403sicke_d
sickee124622223sicke_e
sicken124615253sicke_n
sicker124023903sicke_r
sickies133717503sickies
sickles133417543sickles
sickness1437833sickness
sickos125112033sick_os
sickouts1455503sickouts
sicks115127623sick__s
signets83311503signets
sikes96236083si_ke_s
sinkers113618543sinkers
sippets113310183sippets
slickens14317263slickens
slickers143112553slickers
slickest14229253slickest
snickers143010963snickers
socket123923523socket_
stackers143413563stackers
sticked144114633sticke_d
sticker133515883sticke_r
stickies142211973stickies
stickiest15229603stickiest
stickit1339463stickit_
sticklers15227393sticklers
stickles142512103stickles
stickouts1553973stickouts
sticks125118613stick__s
stickums1643943stickums
stickups1643303stickups
stinkers123111133stinkers
stockers143411073stockers
suckers133717623suckers
sunkets113511283sunkets
tablets94714383tablets
taces76237803tac_e_s
tacet75840023tac_et_
taches114224173tache_s
tacked134723943tacke_d
tacker124224503tacke_r
tackey154613083tacke_y
tackiest143112433tackiest
tacklers143010773tacklers
tackles133816523tackles
tackless14419483tackless
tacks115430133tack__s
tacts76524123tac__ts
takers103923743t_akers
takes94437793t_ake_s
talkers113513213talkers
tankers113416913tankers
tappets113610013tappets
targets84314223targets
tassets75012773tassets
telnets738373telnets
tenets65518953t_enets
tercets93512443tercets
terrets72913583terrets
tets45847463t___ets
thicken16317873thicke_n
thicker163611023thicke_r
thicketed1943613thicketed
thickness1844443thickness
thicks154511993thick__s
thickset17257133thickset_
thinkers15308703thinkers
ticals83214713tic_als
ticced11438443ticce_d
tick106231223tick___
ticketing1635633ticketing
ticketless1641933ticketless
ticking143218753ticking
tickings15368583tickings
tickle124616743tick_le
tickled144313133tickled
tickler133612653tickler
ticklish1755283ticklish
tickseed1584513tickseed
tickseeds1673223tickseeds
tics65729633tic___s
tictacs1145793tictacs
tictocs1145903tictocs
tidbits1035183tidbits
tides64830153ti_de_s
tidiers8389773tidiers
tidies74721833tidie_s
tidiest83514873tidiest
tieless72512563tieless
tiers55526523ti__ers
ties45248313ti__e_s
tigers75616513ti_gers
tights104015853ti_ghts
tigress836093tigress
tike85534483ti_ke__
tikis95615973ti_k_is
tikkas934523ti_kkas
tildes74513963tilde_s
tilers63523503ti_lers
tiles55542103ti_le_s
tillers73418743tillers
tilters73315953tilters
tilts55325613ti__lts
timbers113111853timbers
timers84420993ti_mers
times75630823ti_me_s
tincts84510803ti_ncts
tinders84219173tinders
tineas64616483ti_neas
tines54848423ti_ne_s
tinges74722333tinge_s
tiniest73020123tiniest
tinker103619923tinke_r
tinklers12298183tinklers
tinkles113713923tinkles
tinners73717313tinners
tinsels738373tinsels
tinters74221113tinters
tints56030923ti__nts
tipcarts1244573tipcarts
tipcats1137103tipcats
tipless92610063tipless
tippers113414353tippers
tippet103917873tippet_
tires55437493ti_re_s
titbits935803titbits
titers64526413ti_ters
titfers10318933titfers
tithers104216733tithers
tithes94720213tithe_s
titles63719923title_s
titres64718933titre_s
tits46145043ti___ts
titters74219623titters
tochers123413093tochers
toilets74112913toilets
tokens104711563t_okens
tokers104818893t_okers
tokes95234973t_oke_s
tonlets73212503tonlets
toquets16367863toquets
trackers143512853trackers
trets55928023t__rets
trevets10499973trevets
triceps11267343tric_eps
trices84826333tric_e_s
tricked144016163tricke_d
tricker134615523tricke_r
trickery17297343trickery
trickiest1549023trickiest
trickles143013763trickles
tricks125319013trick__s
tricots9311563tric_ots
trijets14308263trijets
trikes105419493trike_s
trinket11314813trinket_
triolets83410143triolets
triplets103510263triplets
trippets12357423trippets
trivets103911583trivets
trokes104019263troke_s
truckers14279013truckers
tucked134017493tucke_d
tucker124316953tucke_r
tucks114721123tuck__s
tuffets13266523tuffets
turkeys1434523turkeys
turrets73010673turrets
tuskers113710043tuskers
tweets94210103t_weets
twinjets1842413twinjets
twinsets1133663twinsets
tykes125817063t_yke_s
vices105725533vic_e_s
violets102210003violets
wackes154717713wacke_s
wackest164710863wackest
whickers20297983whickers
wiches144418753wiche_s
wicked164317413wicke_d
wicker154518673wicke_r
wickless1736083wickless
wicks144619363wick__s
widgets12318453widgets
wiglets113411423wiglets
willets104414323willets
winkers143517113winkers
yikes125117753yi_ke_s
zibets1737743zi_bets

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.420425454.8
2DLD Change Limit1340274616.65620136.3
3Display Results4614610.1562955.1
 (SQL Overall)1786914617.23224708.4
 
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.