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 “plack” 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
plack13501784(None) 
alack114820061alack
black134719071black
clack134720171clack
flack144519411flack
lack105837681_lack
pack125535441p_ack
place94824611place
placks144414151placks
plank115221141plank
pluck134212301pluck
slack115021761slack
aback134816172aback
back125535762_back
blacks144914952blacks
blank115418552blank
block134917842block
clach124617822clach
clacks144516342clacks
clank114719522clank
click135217952click
clock134917982clock
cluck134914892cluck
crack134120532crack
flacks154114532flacks
flak116026172fla_k
flank124618092flank
flask125512422flask
fleck148213592fleck
flick145017212flick
flock144717422flock
glace87420162glace
hack135134542_hack
jack175224862_jack
klick105311432klick
knack104311042knack
kyack13468262kyack
lac510155822_lac_
lace66848472_lace
lacks116129202_lacks
lacs66942482_lacs
lacy95829632_lacy
lank84734452_lank
lark85733862_lark
lick106935072_lick
lock106134362_lock
luck105329822_luck
mack125733652_mack
pac79054082p_ac_
paca85132242p_aca
pace86345772p_ace
packs135528932p_acks
pacs85842182p_acs
pact86648722p_act
pacy115328682p_acy
paik105726802p_aik
palace104516922palace
park105237492p_ark
peace95026082peace
peach125422492peach
peak106535202pea_k
peck125730682p_eck
pick125933812p_ick
placed114318002placed
placer105117742placer
places104323702places
placet103923672placet
placid114012542placid
placket15412872placket
plage84520402plage
plaice10311552plaice
plaid85118302plaid
plain74823302plain
plait75631572plait
plan65833942pla_n
planch133711442planch
plane74929142plane
planks124116752planks
plans75731272plans
plant75437112plant
plash104616562plash
plasm94114632plasm
plat66048872pla_t
plate74635112plate
plats75531372plats
platy105021662platy
play95928982pla_y
playa105812942playa
plays106320772plays
plaza164311062plaza
pleach134211242pleach
plica9613372plica
plink115219122plink
plonk114613982plonk
plucks14379732plucks
plucky17406582plucky
plunk114514402plunk
poach124917862poach
pock126129292p_ock
pollack1567332pollack
prank115019452prank
prick134317502prick
puck124927942p_uck
quack203812502quack
rack106234882_rack
sack105337312_sack
shack145321752shack
slacks124416532slacks
slank95822772slank
slick115520522slick
smack134615452smack
snack114718062snack
stack114421692stack
tack106536292_tack
thack144915172thack
track114823012track
wack135330912_wack
whack174813022whack
wrack145413882wrack
yack135425972_yack

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.313570897.8
2DLD Change Limit538001201.57634137.1
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.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.