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

209 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
shirtiest123932(None) 
shiftiest1537361shiftiest
shittiest1238331shittiest
chertiest1438792chertiest
chirpiest16286472chirpiest
dirtiest93014202_dirtiest
flirtiest1236192flirtiest
shiniest113212492shi_niest
shirtier1137942shirtie_r
shirtless12266412shirtless
shortest11310782short_est
shorties11414582shorties_
siltiest83515612s_iltiest
slittiest938202slittiest
smirkiest1535192smirkiest
spiriest102513452spir_iest
sportiest111711022sportiest
swirliest1236292swirliest
thirstiest1343972thirstiest
thirties1139722thirties_
whirliest15216042whirliest
whitiest14259882whi_tiest
airiest74221013_air_iest
artiest73121993__artiest
bhisties1339003bhisties_
bittiest103012043_bittiest
chariest13315503char_iest
charriest1438253charriest
chartist131112133charti_st
chattiest1448203chattiest
chestiest1438313chestiest
chichiest1936343chichiest
chilliest14358913chilliest
chinkiest1867023chinkiest
chintziest2443253chintziest
chippiest18256803chippiest
chirkest1735383chir_kest
chitties13310773chitties_
daintiest1039153daintiest
dictiest113212783_dictiest
dirties83119383_dirties_
driftiest1335943driftiest
feistiest1237073feistiest
firriest112310433_firriest
flintiest1248433flintiest
ghostiest1336543ghostiest
girliest93010403_girliest
glintiest1037623glintiest
grittiest10176983grittiest
guiltiest1035713guiltiest
hairiest11612463hair_iest
hardiest123416333_hardiest
hastiest112916493_hastiest
heartiest12311103heartiest
heftiest1439183_heftiest
herbiest1339993_herbiest
hilliest113914113_hilliest
hinkiest153311753_hinkiest
hippiest152611613_hippiest
hissiest112911093_hissiest
hootiest113115643_hootiest
horniest112814043_horniest
horsiest112513263_horsiest
lintiest82715913_lintiest
miltiest103015173_miltiest
mintiest103217143_mintiest
miriest93619823_mir_iest
mirkiest142910253_mirkiest
mistiest103018313_mistiest
mitiest93520053_mi_tiest
niftiest112910073_niftiest
nittiest82712603_nittiest
paintiest11310563paintiest
pointiest1139623pointiest
purtiest102414113_purtiest
quirkiest2234373quirkiest
saintliest1046013saintliest
saltiest83117713s_altiest
sarkiest123615063s_arkiest
scantiest112611003scantiest
scariest101615943scar_iest
scarriest11188393scarriest
scattiest11268363scattiest
schiziest2343913schi_ziest
schizziest2342283schizziest
scurfiest14236863scurfiest
scurviest14266123scurviest
shabbiest1635323shabbiest
shadiest121711273sh_adiest
shaggiest14156893shaggiest
shakiest151910933sh_akiest
shaliest111415053sh_aliest
shanties113116583shanties_
sharpest1339143shar_pest
sharpies13411223sharpies_
sheeniest12158353sheeniest
shelliest1238023shelliest
shelties111111383shelties_
shelviest1535003shelviest
sherries111812893sherries_
shiest95821523sh___iest
shiftier1436343shiftie_r
shiftiness1644793shiftiness
shiftless15265303shiftless
shimmies15287803shimmies_
shindies122610503shindies_
shinnies113010913shinnies_
shires95225573shir__es_
shirtdress1441813shirtdress
shirting123213613shirti_ng
shirtings13276603shirtings
shirts94918343shirt__s_
shirtwaist1652443shirtwaist
shitless11249243shi_tless
shitlist1148723shi_tlist
shittier1137313shittie_r
shittims1344423shittims_
shoaliest1238503shoaliest
shoddiest1434753shoddiest
shortias1148093shortias_
shortie10411343shortie__
shortish1437423shorti_sh
shortlist1246683shortlist
shortness1236733shortness
showiest1438783sh_owiest
shriekiest1743143shriekiest
shrillest1245393shrillest
shrimpiest1743323shrimpiest
shtickiest1943283shtickiest
silkiest123212853s_ilkiest
silliest84017103s_illiest
sirupiest1154753s_irupiest
sissiest83412353s_issiest
sixties14310973s_ixties_
siziest16311473s_i_ziest
skiddiest1543813skiddiest
skimpiest1734503skimpiest
skinniest1335523skinniest
skirtless13254423skirtless
slatiest82616263s_latiest
sleetiest938553sleetiest
slimiest10310743sli_miest
slimsiest1135883slimsiest
slinkiest13188073slinkiest
slippiest1346463slippiest
sluttiest937333sluttiest
smarmiest1335903smarmiest
smartest10310183smart_est
smarties10312873smarties_
smuttiest1135973smuttiest
snarkiest13207633snarkiest
snarliest91810203snarliest
sniffiest15236003sniffiest
snippiest1345723snippiest
snootiest9178753snootiest
snottiest9167973snottiest
snoutiest9178253snoutiest
sootiest84016753s_ootiest
sorriest8413883s_orriest
sorties74126403s_orties_
sparkiest15188093sparkiest
sparriest11198783sparriest
spheriest1438373spher_iest
spiciest122711603spi_ciest
spiffiest17235653spiffiest
spikiest14259533spi_kiest
spiniest102813223spi_niest
spiritist1148093spiritist
spottiest11177683spottiest
spriest92718643s_pr_iest
squintiest1944993squintiest
squirmiest2142793squirmiest
starriest9159763starriest
stickiest15229603stickiest
stilliest939223stilliest
stingiest10209773stingiest
stinkiest13198463stinkiest
stormiest1137003stormiest
stripiest1138013stripiest
sturdiest10207393sturdiest
sultriest938653sultriest
surfiest112414433s_urfiest
surliest82416913s_urliest
swarthiest1644743swarthiest
sweatiest1238413sweatiest
swiftest1434353swift_est
swimmiest1634253swimmiest
swingiest13207573swingiest
swishiest1535513swishiest
tartiest82718313_tartiest
thirtieth1552593thirtieth
thistliest1344383thistliest
thorniest1236483thorniest
thriftiest1643113thriftiest
twirliest1234503twirliest
twistiest1235433twistiest
wartiest113614643_wartiest
whiniest14298753whi_niest
whinniest15245133whinniest
whippiest19265113whippiest
whirlies14167373whirlies_
whirries14136693whirries_
whitest133710113whi_t_est
whities133113253whi_ties_
whizziest2342883whizziest
wiftiest14279173_wiftiest
wiriest103816853_wir_iest
wittiest112711523_wittiest
wristiest1237753wristiest

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 Filter1786911486410.420425454.8
2DLD Change Limit1486412096.67322275.0
3Display Results2092090.0932247.3
 (SQL Overall)1786912097.18624866.5
 
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.