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

109 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
stemmiest133514(None) 
steamiest1138411steamiest
gemmiest13227632_gemmiest
scummiest1535212scummiest
seamiest102715422s_eamiest
seemliest1145622seemliest
slummiest1335672slummiest
steadiest1038522steadiest
steeliest939642steeliest
stemmier1245252stemmie_r
stormiest1137002stormiest
streamiest1245122streamiest
stumpiest1335862stumpiest
swimmiest1634252swimmiest
beamiest123212763_beamiest
chummiest1834643chummiest
clammiest1535743clammiest
creamiest13248933creamiest
crummiest1545563crummiest
dreamiest12227223dreamiest
elmiest9310743__elmiest
gammiest13339333_gammiest
germiest11249923_germiest
gleamiest1235313gleamiest
gremmies1355993gremmies_
gummiest13269033_gummiest
hammiest152610013_hammiest
hempiest1539043_hempiest
jammiest19307203_jammiest
jemmies18318333_jemmies_
plummiest1544973plummiest
rammiest12299933_rammiest
rheumiest1442863rheumiest
rummiest12299353_rummiest
sedgiest10259763s_edgiest
seediest92714053s_eediest
seepiest102412633s_eepiest
sexiest142112223s_e_xiest
shammies15259693shammies_
sheeniest12158363sheeniest
shelliest1238033shelliest
shelviest1535013shelviest
shimmies15287803shimmies_
skimpiest1734513skimpiest
sleaziest1836063sleaziest
sleekiest1336073sleekiest
sleepiest1136723sleepiest
sleetiest938563sleetiest
slimiest10310753s_limiest
slimmest1235903slimm_est
slimsiest1135893slimsiest
smarmiest1335913smarmiest
smeariest1138123smeariest
smelliest1136603smelliest
sneakiest13176843sneakiest
sneeriest939313sneeriest
sneeziest1845153sneeziest
speediest1257473speediest
spendiest1237533spendiest
spumiest1238213s_pumiest
staggiest11148263staggiest
stagiest91613413st_agiest
stalkiest1347913stalkiest
starriest9159773starriest
steadies9311123steadies_
steamier1048303steamie_r
steaminess1236773steaminess
steelies8312553steelies_
steepest1038123ste_epest
stemless1036653ste_mless
stemmas11256973stemm_as_
stemmed12278153stemm_e_d
stemmer113210183stemm_e_r
stemmeries1445173stemmeries_
stemmers12378443stemm_ers
stemmery15334693stemm_ery
stemming13408203stemmi_ng
stenchiest1545083stenchiest
sternest8314433ste_rnest
stickiest15229603stickiest
stilliest939223stilliest
stimies9316563st_imies_
stingiest10209773stingiest
stinkiest13198463stinkiest
stockiest15207753stockiest
stodgiest1135653stodgiest
stoniest8413543st_oniest
strawiest1237223strawiest
streakiest1444773streakiest
stripiest1138023stripiest
stubbiest1345483stubbiest
studliest1036573studliest
stuffiest15235953stuffiest
sturdiest10207393sturdiest
stymies1239213st_ymies_
swampiest1635033swampiest
sweatiest1238423sweatiest
sweepiest1435683sweepiest
tammies113814683_tammies_
teariest82417263_teariest
techiest1359833_techiest
teeniest82112413_teeniest
tempest1139223_te_mpest
tentiest82115613_tentiest
testiest82715223_testiest
thymiest1634733_thymiest
tommies113812983_tommies_
tummies113012033_tummies_
yummiest15256723_yummiest

Search took 9 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.423422437.4
2DLD Change Limit1486411097.68619339.2
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.15521911.8
 
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.