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

247 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
ritziest1723784(None) 
ditziest18218471ditziest
bitsiest102610062bitsiest
bittiest103012042bittiest
ditsiest92111322ditsiest
dizziest17266722dizziest
fizziest19226072fizziest
frizziest20294142frizziest
glitziest1944002glitziest
grittiest10176982grittiest
mitiest93520052mit_iest
nittiest82712602nittiest
pithiest132711442pithiest
rattiest83516112rattiest
ribbiest1237582ribbiest
ridgiest1038902ridgiest
rimiest93215852ri_miest
riskiest12310132riskiest
ritzes154812942ritz_es_
ritzier16297202ritzie_r
ritziness1835822ritziness
ruttiest82712662ruttiest
siziest16311472si_ziest
withiest142411242withiest
wittiest112711522wittiest
airiest74221013ai_riest
antsiest8511463antsiest
artiest73121993art_iest
artsiest879653artsiest
battiest104115553battiest
bilgiest11309883bilgiest
bitchiest1636083bitchiest
booziest19379263booziest
brattiest1148103brattiest
breeziest2035063breeziest
brickiest1737433brickiest
briniest102812323bri_niest
bristliest1245143bristliest
brittlest11146193brittlest
bronziest2035813bronziest
cattiest103016333cattiest
chintziest2443253chintziest
cities84524853cit_ies_
coziest184014353_coziest
craziest19319923craziest
crimpiest15237183crimpiest
crispiest13197423crispiest
diciest103316523di_ciest
dickiest153412503dickiest
dictiest113212783dictiest
dingiest102915363dingiest
dinkiest133812873dinkiest
dippiest132511133dippiest
dirtiest93014203dirtiest
dishiest12313683dishiest
ditheist1249493ditheist
ditties83116983ditties_
ditzes163212423ditz_es_
ditzier17307963ditzie_r
ditziness1945883ditziness
dizzies16279753dizzies_
dotiest83717453dot_iest
dottiest92611393dottiest
doziest174012473_doziest
driftiest1335943driftiest
drippiest1445363drippiest
drizzliest19122533drizzliest
fattiest113514313fattiest
fieriest112112243fieriest
filmiest1338553filmiest
filthiest1545373filthiest
finniest113011403finniest
firriest112310433firriest
fishiest14310453fishiest
fittest102510803fit_test
foziest194110943_foziest
frettiest1267063frettiest
frilliest1237113frilliest
fringiest1347603fringiest
friskiest1636233friskiest
fritzes19329453fritz_es_
frizzies19315933frizzies_
frizzliest21132933frizzliest
frothiest1537453frothiest
frouziest2143973frouziest
frowziest2443483frowziest
fruitiest1237383fruit_iest
furziest20267783furziest
fuzziest19235793fuzziest
gauziest1836233gauziest
giddiest11298553giddiest
gimpiest1338473gimpiest
ginniest92610503ginniest
girliest93010403girliest
glaziest18227913glaziest
grimiest11299823gri_miest
gripiest11289633gri_piest
grippiest1435143grippiest
grisliest1047353grisliest
gristliest1154983gristliest
grizzliest19152823grizzliest
grottiest10147183grottiest
gutsiest92610583gutsiest
guttiest92311223guttiest
haziest193313003_haziest
hilliest113914113hilliest
hinkiest153311753hinkiest
hippiest152611613hippiest
hissiest112911093hissiest
iciest82914743_i_ciest
ickiest133611043_ickiest
iffiest1337953_iffiest
inkiest113415043_inkiest
itchiest1336523_itchiest
jazziest2333813jazziest
jettiest15359593jettiest
jiggiest17277693jiggiest
jiviest1738113ji_viest
kickiest13319673kickiest
kinkiest113110503kinkiest
kitties113213623kitties_
kittlest12297573kittlest
klutziest2242803klutziest
lathiest11312653lathiest
laziest163814473_laziest
limbiest12258883limbiest
limiest93716103li_miest
lingiest93715243lingiest
liniest73321153li_niest
lintiest82715913lintiest
lippiest122310613lippiest
lithest10513913lit_hest
littlest8309243littlest
matiest92522453mat_iest
maziest183613873_maziest
miffiest1637123miffiest
milkiest142911083milkiest
miltiest103015173miltiest
minciest122913103minciest
mingiest113315813mingiest
mintiest103217143mintiest
miriest93619823mi_riest
mirkiest142910253mirkiest
mistiest103018313mistiest
mothiest13311033mothiest
motliest10310773motliest
muzziest18175833muzziest
mythiest1636033mythiest
nattiest83215353nattiest
nettiest83112433nettiest
niftiest112910063niftiest
nippiest12279973nippiest
nutsiest82710233nutsiest
nuttiest82312133nuttiest
oiliest72817683oi_liest
ooziest163411523_ooziest
pettiest103113963pettiest
pickiest162712593pickiest
piggiest12259663piggiest
piniest93121133pi_niest
pipiest113114493pi_piest
pitchiest1646703pitchiest
pities83828083pit_ies_
pottiest102815973pottiest
prettiest1199803prettiest
priciest122112903pri_ciest
prickiest1748183prickiest
prissiest11178893prissiest
priviest132310313pri_viest
raciest92820013r_aciest
rainiest81214923rainiest
rammiest12299933rammiest
randiest93418773randiest
rangiest93115983rangiest
raspiest10311273raspiest
readiest93719043readiest
reediest92815423reediest
reefiest112811483reefiest
reekiest122711313reekiest
retest64028453ret__est
reties65436193ret_ies_
retries74129073retries_
retwist1039483retwi_st
richest122813683ri_chest
rifest93114583ri__fest
rightest12149583rightest
ripest84317933ri__pest
rippliest1334763rippliest
rites54442553rit__es_
ritzily1945143ritzi_ly
rockiest142912223rockiest
roiliest8312283roiliest
rookiest122912173rookiest
roomiest102611993roomiest
rootiest83115593rootiest
ropiest93317773r_opiest
rosiest73919213r_osiest
roupiest102610293roupiest
rowdiest12259213rowdiest
rubiest92914423r_ubiest
ruddiest10278543ruddiest
ruliest72816423r_uliest
rummiest12299353rummiest
runniest82911203runniest
runtiest83014513runtiest
rushiest113312923rushiest
rustiest83116803rustiest
shittiest1238333shittiest
silkiest123212853silkiest
silliest84017093silliest
siltiest83515613siltiest
sissiest83412353sissiest
slittiest938203slittiest
tattiest83415383tattiest
tidiest83514873ti_diest
tiniest73020123ti_niest
tinniest82911463tinniest
tippiest122310013tippiest
tipsiest10228953tipsiest
titlist7312923titli_st
titties73617363titties_
tizzies15287893tizzies_
trickiest1549023trickiest
trippiest1336583trippiest
tritest7315273trit__est
tritheist1247203tritheist
viewiest1435853viewiest
viniest103216613vi_niest
whitiest14259883whit_iest
whizziest2342883whizziest
wiftiest14279173wiftiest
wiggiest13269013wiggiest
wiliest103416593wi_liest
wimpiest1538763wimpiest
windiest122213233windiest
wingiest123214273wingiest
winiest103419693wi_niest
wintriest1238153wintriest
wiriest103816853wi_riest
wispiest1339513wispiest
witchiest1736313witchiest
withies133913543withies_
wooziest20327903wooziest
wrathiest1536973wrathiest
wristiest1237753wristiest
zingiest182810883zingiest
zippiest21248093zippiest

Search took 8 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 Filter1786911461620.1601116818.8
2DLD Change Limit1461622476.95021030.5
3Display Results2472470.0962572.9
 (SQL Overall)1786912477.20624797.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.