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

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

140 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
prissiest1117890(None) 
prissies101712001prissies_
brassiest11369712brassiest
crispiest13197422crispiest
dressiest1036822dressiest
drossiest1036522drossiest
friskiest1636232friskiest
grassiest10309512grassiest
grisliest1047352grisliest
hissiest112911092_hissiest
priciest122112902pri_ciest
prickiest1748182prickiest
prisses94816712priss_es_
prissier10157872prissie_r
prissiness1266132prissiness
priviest132310312pri_viest
prosiest10416522pr_osiest
prossies101515222prossies_
pussiest102911752p_ussiest
riskiest12310132_riskiest
sissiest83412352_sissiest
tressiest937882tressiest
wristiest1237752wristiest
artsiest879653ar_tsiest
bitsiest102610063_bitsiest
bossiest103112213_bossiest
brashiest14359853brashiest
brassies103613533brassies_
brickiest1737433brickiest
briniest102812323bri_niest
briskest14337803bri_skest
brisses94314313briss_es_
bristliest1245143bristliest
brushiest14297543brushiest
cissies94116153_cissies_
classiest11309543classiest
crassest103411523crass_est
creasiest11229943creasiest
crimpiest15237183crimpiest
crispest12177373cri_spest
crossest1012012123cross_est
crustiest112410053crustiest
dishiest12313683_dishiest
ditsiest92111323_ditsiest
driftiest1335943driftiest
drippiest1445363drippiest
drowsiest1334993drowsiest
feistiest1237073feistiest
fishiest14310453_fishiest
flimsiest1434463flimsiest
flossiest12296803flossiest
frilliest1237113frilliest
fringiest1347603fringiest
frizziest20294143frizziest
frostiest1239213frostiest
frowsiest1535063frowsiest
fussiest112910493_fussiest
gassiest93212523_gassiest
glassiest10279243glassiest
glossiest10277943glossiest
greasiest10208563greasiest
grimiest11299823gri_miest
gripiest11289633gri_piest
grippiest1435143grippiest
gristliest1154983gristliest
grittiest10176983grittiest
grossest93810093gross_est
hissies103915823_hissies_
massiest103314423_massiest
messiest103112423_messiest
missies93423983_missies_
mistiest103018313_mistiest
mossiest103112443_mossiest
mussiest103112933_mussiest
noisiest839763noi_siest
paintiest11310563paintiest
pastiest103319543p_astiest
peskiest142610163p_eskiest
pestiest103018413p_estiest
pickiest162712593p_ickiest
piggiest12259663p_iggiest
piniest93121133p_i_niest
pipiest113114493p_i_piest
pisses84525083p_iss_es_
pithiest132711443p_ithiest
plashiest1478373plashiest
pliskies1475973pliskies_
plisses94411773pliss_es_
plushiest1466393plushiest
pointiest1139623pointiest
poussies1038113poussies_
precisest13259003precisest
preppiest1236973preppiest
prescient13411323prescient
presses93523153press_es_
prettiest1199803prettiest
prickliest1845293prickliest
priest84125423pr___iest
priestess1145293priestess
priestliest13103583priestliest
primmest14226693pri_mmest
primsie1137543primsie__
priories10312453priories_
priseres10310823priseres_
prises84133173pri_s_es_
prissed103311263priss_e_d
prissily1346693prissi_ly
prissing113011453prissi_ng
privatest14196733privatest
privies122414263pri_vies_
prosaist10611583prosai_st
prosses94019513pross_es_
prossie91812953prossie__
prosties101421193prosties_
pursiest102812123p_ursiest
pushiest133211713p_ushiest
pussies93615693p_ussies_
raspiest10311273_raspiest
ribbiest1237583_ribbiest
ridgiest1038903_ridgiest
rimiest93215853_ri_miest
ritziest17237843_ritziest
rosiest73919213_r_osiest
rushiest113312923_rushiest
rustiest83116803_rustiest
sassiest83413613_sassiest
sissies73716603_sissies_
slimsiest1135883slimsiest
spriggiest14174533spriggiest
springiest13156673springiest
swishiest1535513swishiest
tipsiest10228953_tipsiest
trashiest123110633trashiest
trickiest1549023trickiest
tricksiest1644353tricksiest
trippiest1336583trippiest
trustiest9239083trustiest
twistiest1235433twistiest
wispiest1339513_wispiest
wussiest11268663_wussiest

Search took 7 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411406.29623608.8
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.51527427.6
 
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.