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

148 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
shoalest116891(None) 
shoaliest1238501shoaliest
halest94823272_h_alest
shales94731252sh_ales_
shaliest111415052sh_aliest
shoaled113810972shoale_d
shoaler102610082shoale_r
shoals94215792shoal_s_
shoeless1137802shoeless
shortest11310782shortest
shouldest1344142shouldest
shouldst1243392shouldst
showiest1438782showiest
stalest73720172s_talest
arbalest1039523arbalest
broadest1138573broadest
chalet113825993ch_ale_t
chalets122813473ch_alets
cheapest1536073cheapest
chillest13259593chillest
choicest15226453choicest
chokiest1738723chokiest
cholent12313253cho_lent
chorales133712883chorales_
coaliest10316223_coaliest
coolest9318643_coolest
dholes104914793dho_les_
drollest937353drollest
foulest10313313_foulest
hales85449843_h_ales_
haoles94919803_haoles_
hoariest11312883_hoariest
hoarsest1137133_hoarsest
hoaxes163611693_hoaxes_
hokiest144114243_hokiest
holes84748653_ho_les_
holiest104319623_holiest
holist94723213_ho_list
homiest124116633_homiest
honest94822423_ho_nest
hottest10411383_hottest
howlet123518343_howle_t
howlets13329223_howlets
hoyles12315013_hoyles_
loyalest11146723loyalest
molest85022743_mo_lest
noblest93613563_noblest
palest83926223__palest
phoniest132811533phoniest
realest73322433_realest
safest95016603s__afest
sagest74920263s__agest
sales56055593s__ales_
saltest71916513s__altest
sanest64426693s__anest
savagest1245763savagest
sayest94217743s__ayest
scales84529313s_cales_
scaliest101714393s_caliest
searest73322023s_earest
sedatest9249393sedatest
shades105924533sh_ades_
shadiest121711273shadiest
shakes135024593sh_akes_
shakiest151910933shakiest
shale85332833sh_ale__
shaled105023953sh_ale_d
shaley123714993sh_ale_y
shallot103614133sh_allot
shalt85534493sh_al__t
shames114726223sh_ames_
shapes115124943sh_apes_
shares95236413sh_ares_
sharpest1339143sharpest
shaves125224933sh_aves_
sheals94420643sheal_s_
sheaves134412973sheaves_
sheerest11310083sheerest
shelliest1238023shelliest
shiest95821523sh__iest
shiniest113212493shiniest
shipless13277693shipless
shitless11249243shitless
shitlist1148723shitlist
shoal83920273shoal___
shoalier1137073shoalier
shoaling123111753shoaling
shoaly124010773shoal__y
shoat85633953shoa___t
shoats94117083shoa_ts_
shoddiest1434753shoddiest
shoes85429663sho__es_
shooled115212663shoole_d
shools94919013shool_s_
shoplift1645193shoplift
shoppes143411393shoppes_
shoreless1236633shoreless
shores94830413sho_res_
shorls94516203shorl_s_
shortlist1246683shortlist
shotes95321913sho_tes_
shovels13378393shovels_
shoves124919423sho_ves_
shrillest1245393shrillest
shyest125511833sh__yest
simplest122310223simplest
skoaled12226063skoale_d
skoals10438243skoal_s_
slowest10168713slo_west
smallest1039403smallest
smogless1134053smogless
smokiest1437883smokiest
snellest839493snellest
snowiest1138143snowiest
snowless1145633snowless
soapiest102412843s_oapiest
soapless10278073s_oapless
soaves94218673s_oaves_
socles8418453s_ocles_
sodaless936113sodaless
sodalist9311883sodalist
softest10310603s_oftest
soles55547923s_o_les_
sonless72612613s_onless
soonest7415593s_oonest
soothest113312243soothest
sootiest84016753sootiest
sorest65028003s_o_rest
sourest7515713s_ourest
spales84728103s_pales_
sparest94616423s_parest
spotless1037043spotless
squarest17338223squarest
stablest103312943stablest
stales65538293s_tales_
stillest8311073stillest
stoles63927673sto_les_
stoniest8413543stoniest
stoutest837613stoutest
suavest10310623s_uavest
subtlest10511363subtlest
supplest1248943supplest
swales93920763s_wales_
swellest1137663swellest
tholes94919783tho_les_
thowless1434613thowless
whales124716943wh_ales_
wholes124616773who_les_

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.530337152.8
2DLD Change Limit1461621486.59322169.3
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.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.