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 “tricksiness” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
tricksiness176294(None) 
trickiness1666351trick_iness
prickliness1943902prickliness
trickishness2152522trickishness
tricksiest1644352tricksi_est
tricksinesses1962432tricksinesses
friskiness1744453frisk_iness
ickiness1436753__ick_iness
pickiness1737623_pick_iness
prissiness1266133pri_ssiness
riskiness1336963_risk_iness
rockiness15237833_rock_iness
sickliness1645003_sickliness
stickiness1635903stick_iness
tackiness1557693t_ack_iness
thickness1844443thick__ness
tipsiness1135703t_i_psiness
tracksides1744163trackside_s
trickiest1549023trick_i_est
trickinesses1845223trick_inesses
trickliest1646433trickli_est
tricksier15275243tricksi_e_r
tricksters16264763tricks_ters
tricotines1247453tricotine_s
trucklines1644293truckline_s
agribusiness1551364agribusiness
arccosines1443164arccosine_s
arcsines104010344ar_c_sine_s
artsiness937654ar__tsiness
brackishness2352454brackishness
brassiness1235484br_assiness
brickiest1737434brick_i_est
brininess1138204bri__niness
briskness1544764bri__skness
cockiness17248784_cock_iness
cosiness103214284___cosiness
crankiness1636174crank_iness
creakiness1645964creak_iness
crispiness1444794cri_spiness
crispness1345304cri__spness
ditsiness1048144_di_tsiness
dressiness1145544dr_essiness
drowsiness1443644dr_owsiness
fickleness1943664_fickleness
finickiness2052024finick_iness
flimsiness1543454fli_msiness
folksiness1743574_folksiness
freakiness1745184freak_iness
frizziness2142714fri_zziness
greasiness1156544gr_easiness
griminess1236704gri__miness
grisliness1155144gri_sliness
gristliness1264004gristliness
grittiness1145164gri_ttiness
iciness938864__ic__iness
inkiness1238694__ink_iness
juiciness1835154juic__iness
kinkiness1235764_kink_iness
luckiness1596574_luck_iness
milkiness1536524_milk_iness
noisiness948344noi__siness
pluckiness1883824pluck_iness
preciseness1545784preciseness
prickiest1748184prick_i_est
prickings18315654prick_in_gs
prickliest1845294prickli_est
pricklinesses2143624pricklinesses
princeliness1653014princeliness
prosiness11311684pr__osiness
quickness2443734quick__ness
quirkiness2342824quirk_iness
raciness102413454_rac__iness
richness1337434_ric__hness
riminess10510094_ri__miness
ritziness1835824_ri_tziness
rosiness82613174_r__osiness
sickishness2043654_sickishness
sickness1437834_sick__ness
silkiness1337254_silk_iness
sissiness8217964_si_ssiness
slickness1535904slick__ness
slinkiness1445154slink_iness
spiciness1347054spic__iness
spikiness1536314spi_k_iness
stockiness1645244stock_iness
streakiness1543824streak_iness
strictness1245644stric__tness
stringiness1245264stri_nginess
talkiness1356914t_alk_iness
tetchiness1543584tetc_hiness
thickeners1943464thick_eners
thicksets18263734thicks__ets
thirstiness1442694thirstiness
thriftiness1742474thri_ftiness
ticketless1641934t_icketless
tickings15368584t_ick_in_gs
ticklishness2152334t_icklishness
tickseeds1673224t_icks_eeds
tidiness938794t_i__diness
timeliness1245304t_imeliness
tininess8310634t_i__niness
tinniness936094t_i_nniness
touchiness1544614touc_hiness
trackings16247544track_in_gs
trackless15246724track__less
trackside1644374trackside__
trashiness1346444tr_ashiness
trendiness1146224tr_endiness
triazines1847544tri_azine_s
trichiases1544564tric_hiases
trichinas1446044tric_hin_as
trichinoses1653234tric_hinoses
trichinosis1652634tric_hinosis
trichinous1543624tric_hinous
trichites1448884tric_hite_s
trickeries1647144trickerie_s
trickers143812814trick___ers
trickie132611034trick_i_e__
trickier143010234trick_i_e_r
tricking152714514trick_in__g
trickish1746794trick_i__sh
trickishnesses2352504trickishnesses
trickles143013764trick__le_s
tricklier15256824trickli_e_r
trickling1647724tricklin__g
trickster15265704tricks_te_r
tricornes1146234tric_orne_s
tricotine1148254tricotine__
trigness968404tri___gness
trimness1067564tri___mness
triteness9310364tri__teness
truckings16235024truck_in_gs
truckline1544914truckline__
trustiness1036654tr_ustiness
wackiness1836524_wack_iness
wickedness2043074_wickedness
yuckiness1874924_yuck_iness

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit1488191379.22016140.9
3Display Results1371370.0602283.3
 (SQL Overall)1786911379.71618391.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.