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

120 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
prick13431750(None) 
brick134618151brick
crick135118751crick
pick125933811p_ick
price93725411price
pricks144414261pricks
pricky174210341pricky
pricy124814561pricy
prink114719671prink
rick107334651_rick
trick115420691trick
wrick144013391wrick
bricks144614622bricks
bricky17489092bricky
brink116122002brink
brisk115615982brisk
brock136017072brock
chick165419132chick
click135217952click
crack134120532crack
cricks144316052cricks
crock135921992crock
cruck135615322cruck
dick116432382_dick
dreck124812802dreck
drink106816382drink
erica7316542erica
flick145017212flick
frisk125312372frisk
frock145314652frock
hick135530302_hick
hoick145210682hoick
ick97329322__ick
kick96026072_kick
klick105311432klick
lick106935072_lick
mick126333432_mick
nick106627602_nick
pack125535442p_ack
paik105726802pai_k
peck125730682p_eck
pic76046822p_ic_
pica85831492p_ica
pice84641092p_ice
picks135226142p_icks
picky165416942p_icky
pics85633912p_ics
pink107039382p_ink
plack135017842plack
plica9613372plica
plink115219122plink
pluck134212302pluck
pock126129292p_ock
prank115019452prank
priced115018882priced
pricer103918292pricer
prices104524542prices
pricey134412632pricey
pricked164613832pricked
pricker154013412pricker
pricket153616442pricket
prickle153611012prickle
prickly18367892prickly
pride84724732pride
pried84426862pried
prier75027762prier
pries74339532pries
prig75924872pri_g
prigs85219702prigs
prill74117942prill
prim85132202pri_m
prima95019342prima
prime96525602prime
primi95017402primi
primo95017912primo
primp115615922primp
prims95425932prims
prince104114762prince
prinks124315382prinks
print74837462print
prion75119992prion
prior74316172prior
prise74632612prise
prism94820262prism
priss74623892priss
privy13439832privy
prize164718942prize
puck124927942p_uck
pyic116915822pyic_
pyric123815072pyric_
quick204311062quick
rack106234882_rack
reck106130562_reck
rice64942912_rice
rich97025542_rich
ricks115126132_ricks
rink87736992_rink
risk85724102_risk
rock105735182_rock
ruck104728332_ruck
sick106435572_sick
slick115520522slick
snick114416012snick
spick134519072spick
stick115121562stick
strick124813202strick
thick145613352thick
tick106231222_tick
track114823012track
trice75127492trice
tricks125319012tricks
tricky154211472tricky
trock114817602trock
truck116115462truck
uptick1436762uptick
uric63624942uric_
wick135726302_wick
wrack145413882wrack
wreck144611042wreck
wricks154610622wricks

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 Limit538001201.61033416.1
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.93992156.3
 
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.