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

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

132 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
picky16541694(None) 
dicky154816241dicky
icky136315751_icky
kicky135012331kicky
pecky165515091pecky
pick125933811pick_
picks135226141picks
pinky145823401pinky
pocky165314601pocky
pricky174210341pricky
bricky17489092bricky
cocky164215932cocky
dicey114819332dicey
dick116432382dick_
dickey165913522dickey
dicks125824692dicks
dicty115116292dicty
dinky135819372dinky
ducky154216112ducky
fickly18318532fickly
hick135530302hick_
hickey185011992hickey
hicks145322172hicks
hinky155618752hinky
ick97329322_ick_
icy86322122_ic_y
inky115321582_inky
jacky215412342jacky
kick96026072kick_
kicks104420082kicks
kinky115816382kinky
lick106935072lick_
licks115325392licks
linky127622382linky
lucky145515012lucky
mick126333432mick_
mickey174211852mickey
micks135525372micks
milky144014442milky
mirky146315522mirky
mucky165015252mucky
nick106627602nick_
nicks114920492nicks
pacey126720282pacey
pack125535442pack_
packly17228332packly
packs135528932packs
pacy115328682pac_y
panicky1833852panicky
pawky173810152pawky
peaky145718152peaky
peck125730682peck_
pecks135724432pecks
perky145319482perky
pesky145911562pesky
pic76046822pic__
pica85831492pic_a
pical95524372pical
picas94626522picas
pice84641092pic_e
pickax2135912pickax
picked154421312picked
picker144422172picker
picket144924312picket
pickle144215652pickle
pickup1655632pickup
picot95031012picot
pics85633912pic_s
picul95015362picul
piety105817302piety
piggy124011432piggy
pigmy13299432pigmy
pika106322952pi_ka
pike106335212pi_ke
piki106520562pi_ki
pily96132732pi_ly
piney105727502piney
pink107039382pink_
pinkey154314672pinkey
pinkly155012242pinkly
pinko115618252pinko
pinks115729382pinks
pinny105222062pinny
piny911838352pi_ny
pipy115421512pi_py
pitchy16479672pitchy
pithy135614462pithy
pity96031932pi_ty
pixy166117762pi_xy
plisky1533712plisky
plucky17406582plucky
pock126129292pock_
pocks135022962pocks
poky135922152p_oky
porky145019332porky
pricey134412632pricey
prick134317502prick_
prickly18367892prickly
pricks144414262pricks
pricy124814562pric_y
puck124927942puck_
pucka133412802pucka
pucks134322102pucks
punky144419392punky
rick107334652rick_
rickey154613972rickey
ricks115126132ricks
risky126311522risky
rocky144513852rocky
sick106435572sick_
sickly153110482sickly
sicko115315392sicko
sicks115127622sicks
silky125315822silky
spicey134414232spicey
spick134519072spick_
spicks144814992spicks
spicy125417712spic_y
spiky146014112spi_ky
sticky154711342sticky
sucky144415502sucky
tacky145617442tacky
tick106231222tick_
ticks115823292ticks
tricky154211472tricky
vichy1639042vichy
wacky174714932wacky
wick135726302wick_
wicks144619362wicks
yucky175411692yucky
zincky24404962zincky
zinky215314812zinky

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001321.59633709.3
3Display Results1321320.0304400.0
 (SQL Overall)1786911321.92292971.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.