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

130 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
platy10502166(None) 
paty95234561p_aty
peaty105725691peaty
plat66048871plat_
plate74635111plate
plats75531371plats
platys11459851platys
play95928981pla_y
slaty86523151slaty
alary86123442alary
alate55340322alate
blasty115611052blasty
blat66550952blat_
blate75933782blate
blats75132502blats
clary105719612clary
clay95927412cla_y
elate55335882elate
flaky155715582flaky
flamy135217472flamy
flat77147822flat_
flatly123110212flatly
flats86429742flats
flawy145913382flawy
flaxy189012292flaxy
flay106332802fla_y
floaty124210942floaty
fluty114415642fluty
glady105413942glady
glary96018542glary
glazy187410982glazy
lacy95829632_lacy
lady86527152_lady
laity85318902_laity
laky116725822_laky
lat37593402_lat_
late47560482_late
lath76640382_lath
lathy115215062_lathy
lati46438272_lati
lats45962702_lats
latu47934182_latu
lay68865352_la_y
lazy166423072_lazy
malty106721702malty
meaty107021312meaty
pacy115328682p_acy
palate84226782palate
pally105727122pally
palmy126016732palmy
palsy105417462palsy
paltry114910402paltry
paly95835532p_aly
panty105929302panty
party106630612party
pasty105725052pasty
pat58089462p_at_
pate65350462p_ate
path99134912p_ath
patly105020582p_atly
pats66460852p_ats
patsy105717202p_atsy
patty104723612patty
pay88461182p_a_y
peaky145718152peaky
peat65967932peat_
peats76140192peats
peavy135014842peavy
pesty106421712pesty
petty105320292petty
phat95837862phat_
piety105817302piety
pity96031932p_ity
place94824612place
plack135017842plack
plage84520402plage
plaguy12386412plaguy
plaid85118302plaid
plain74823302plain
plait75631572plait
plaits83816472plaits
plan65833942pla_n
plane74929142plane
plank115221142plank
plans75731272plans
plant75437112plant
plants84921802plants
plash104616562plash
plashy14448872plashy
plasm94114632plasm
platan83913692platan
plated95225772plated
platen84518202platen
plater84427692plater
plates85432242plates
platypi1442752platypi
playa105812942playa
plays106320772plays
plaza164311062plaza
pleat74734472pleat_
pleats85218592pleats
plenty11311412plenty
plot66141232plot_
plots75025672plots
plotty11208852plotty
plotz164617002plotz
ploy96123602pl_oy
plumy124213232plumy
ply86323552pl__y
polity113015862polity
potty105621002potty
pouty107018812pouty
prat65952042prat_
prate75135982prate
prats76333392prats
pray96331532pra_y
punty106021612punty
purty105019402purty
putty104721402putty
salty85524382salty
slanty95114842slanty
slat46959022slat_
slate55438282slate
slatey95417062slatey
slats55436902slats
slay76436382sla_y
splat76129342splat_
splats84817302splats
splay105816042spla_y
zloty17399792zloty

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 Limit538001301.62633087.3
3Display Results1301300.0462826.1
 (SQL Overall)1786911301.98590020.7
 
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.