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

249 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
trickie13261103(None) 
trickier143010231trickier
trickle133613441trickle
brickier16307162brickier
brickle15279932brickle
dickie133913112_dickie
hickie153812472_hickie
prickier16368142prickier
prickle153611012prickle
quickie2235512quickie
sickie123715742_sickie
strickle1467792strickle
tickle124616742t_ickle
trice75127492tric__e
trichite1349332trichite
trick115420692trick__
tricked144016162tricked
tricker134615522tricker
trickiest1549022trickiest
trickily1736232trickily
tricking152714512tricking
trickish1746792trickish
trickled152610432trickled
trickles143013762trickles
tricklier15256822tricklier
trickly16369892trickly
tricks125319012trick_s
tricksier15275242tricksier
tricksy16436582tricksy
tricky154211472trick_y
trike95320162tri_k_e
truckle13358862truckle
twinkie1434572twinkie
bikie113915883_bi_kie
birkie124110133_birkie
brick134618153brick__
bricked164312063bricked
brickiest1737433brickiest
bricking173911403bricking
brickles162810283brickles
bricklike1643113bricklike
bricks144614623brick_s
bricky17489093brick_y
bricole112810493bricole
brookie1347373brookie
chickee183111553chickee
crackle153611253crackle
crick135118753crick__
cricked164814283cricked
cricket154716953cricket
crickey18418143crickey
cricking173412653cricking
cricks144316053crick_s
cricoid1239243cricoid
crinkle13359413crinkle
dickier143512453_dickier
dickies143416343_dickies
duckie133511663_duckie
ericoid1049893ericoid
fickle153912973_fickle
freckle16106643freckle
friskier1535193friskier
grackle14338893grackle
griskin1236013griskin
hackie154615623_hackie
hickies163614743_hickies
ickier12439923__ickier
kickier12349053_kickier
luckie123611413_luckie
mickle143715133_mickle
nickle123814483_nickle
pickier153912973_pickier
pickle144215653_pickle
pinkie124414273_pinkie
pliskie1394543pliskie
price93725413pric__e
pricier113313113pric_ier
prick134317503prick__
pricked164613833pricked
pricker154013413pricker
pricket153616443pricket
prickiest1748183prickiest
pricking173212603pricking
prickled17358073prickled
prickles162511093prickles
pricklier17245063pricklier
prickly18367893prickly
pricks144414263prick_s
pricky174210343prick_y
primsie1137543primsie
quickies2336773quickies
rackle123917293_rackle
rice64942913_ric__e
ricin74620213_ric_in
rick107334653_rick__
ricked136523623_ricked
rickey154613973_rickey
ricking143920233_ricking
ricks115126133_rick_s
riskier1138423_riskier
rockier134911883_rockier
rookie103613263_rookie
ruckle124414583_ruckle
sickee124622223_sickee
sickies133717503_sickies
sickle124418323_sickle
silkie103313403_silkie
stickier14229763stickier
stickies142211973stickies
stickit1339463stickit
stickle132410973stickle
strick124813203strick__
stricken1436893stricken
strickled1665833strickled
strickles1567813strickles
stricks134310693strick_s
strike105619733stri_k_e
tackier133712523t_ackier
tackle123815733t_ackle
talkie103914443t_alkie
techie11511723t_echie
tekkie934203t_ekkie
thick145613353thick__
thicken16317873thicken
thicker163611023thicker
thicket163213073thicket
thickish2044603thickish
thickly19415573thickly
thicks154511993thick_s
thickset17257133thickset
thrice114311573thric__e
tick106231223t_ick__
ticked134720523t_icked
ticker124321503t_icker
ticket124524853t_icket
ticking143218753t_icking
tickled144313133t_ickled
tickler133612653t_ickler
tickles133416853t_ickles
ticks115823293t_ick_s
tike85534483t_i_k_e
tiki87620843t_i_ki_
tikis95615973t_i_kis
tinkle103714453t_inkle
tittie63213153t_ittie
trace75829613trac__e
trachle12311853trachle
track114823013track__
trackage1545653trackage
tracked143716133tracked
tracker133515173tracker
tracking153715463tracking
trackmen1635573trackmen
tracks124818843track_s
trackside1644373trackside
tractile10311073tractile
tractive13310043tractive
triable92515393triable
triacid1038593triacid
triadic1037833triadic
triage72812893tri_age
triazin1638203triazin
triazine1738503triazine
tribade1037293tribade
tribe74420273tri__be
tribune945573tribune
tribute937313tribute
triced95518673tric_ed
tricep103911073tric_ep
triceps11267343triceps
trices84826333tric_es
trichina1348093trichina
trichinae1444703trichinae
trichites1448883trichites
trichoid1457813trichoid
trichome1596953trichome
tricing103417353tricing
trickeries1647143trickeries
trickers143812813trickers
trickery17297343trickery
trickiness1666353trickiness
trickliest1646433trickliest
trickling1647723trickling
tricksiest1644353tricksiest
trickster15265703trickster
triclad1037443triclad
tricorn937963tricorn
tricorne1045963tricorne
tricot8317753tric_ot
tricotine1148253tricotine
tricots9311563tricots
tricycle1543893tricycle
triene64316383tri_ene
trifid1039063tri_fid
trifle94012883tri_fle
trikes105419493tri_kes
trilbies1037693trilbies
trindle83311363trindle
trine54734603tri__ne
trinket11314813trinket
triode75311893tri_ode
triose64715383tri_ose
trioxid1546613trioxid
trioxide1644793trioxide
tripe75425383tri__pe
triple84215923tri_ple
triplite1039103triplite
trippier1246623trippier
tripwire1343603tripwire
trireme935263trireme
triscele1045433triscele
triseme936543triseme
triskele1244573triskele
trismic1137483trismic
trisome9310223trisome
triste63818643tri_ste
trite54730033tri__te
tritone73613883tritone
triune64210183tri_une
trivia938503tri_via
troche113112513troc_he
trochee122613883trochee
trochil1258713trochil
trock114817603trock__
trocked144312243trocked
trocking153612423trocking
trocks123614633trock_s
troke94821053tr_ok_e
truce75118693truc__e
truck116115463truck__
truckage1543633truckage
trucked143910813trucked
trucker134010733trucker
trucking153310163trucking
truckled15327313truckled
truckler14297453truckler
truckles14319383truckles
truckline1544913truckline
truckmen1643373truckmen
trucks124711973truck_s
twice104711123twic__e
twinkies1535983twinkies
twinkle1464773twinkle
utricle937913utric_le
wrick144013393wrick__
wricked174910193wricked
wricking18349493wricking
wricks154610623wrick_s
wrinkle14296923wrinkle

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.1561145455.1
2DLD Change Limit1340272496.31321230.3
3Display Results2492490.0902766.7
 (SQL Overall)1786912496.55927243.6
 
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.