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

106 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
swiftest143435(None) 
shiftiest1537362shiftiest
softest10310602s_oftest
stiffest1435682stiffest
sweetest1137172sweetest
swifter13318052swifte_r
swifters14277482swifters
swiftlet1444792swiftlet
swiftlets1542722swiftlets
swiftness1543652swiftness
swifts12408172swift_s_
wiftiest14279172_wiftiest
daftest11248943_daftest
deftest112611713_deftest
driftiest1335943driftiest
faintest1139073faintest
fittest102510803_fittest
leftest10269463_leftest
moistest1038763moistest
niftiest112910073_niftiest
oftest91212003__oftest
quietest1757173quietest
rifest93114583_rif_est
safest95016603s_af_est
saltest71916513s_altest
scantest101710183scantest
sedatest9249393sedatest
shiest95821523shi__est
shifted14359983shifte_d
shifter132911083shifte_r
shifters14319863shifters
shiftless15265303shiftless
shifts124412943shift_s_
shiniest113212493shiniest
shirtiest1239323shirtiest
shittiest1238333shittiest
shortest11310783shortest
sickest131813793s_ickest
sifted104313673s_ifte_d
sifter94516233s_ifte_r
sifters103714793s_ifters
sifts84918923s_ift_s_
siltiest83515613s_iltiest
sites56045433s_i_tes_
sixtes133612403s_ixtes_
siziest16311473s_iziest
skites104418043ski_tes_
slickest14229253slickest
sliest66621953sli__est
slightest13136943slightest
slimiest10310743slimiest
slimmest1235903slimmest
slittiest938203slittiest
smartest10310183smartest
smites83921923smi_tes_
snidest8310913sni_dest
sniffiest15236003sniffiest
snifter10349623snifte_r
snifters11318613snifters
spiciest122711603spiciest
spiffiest17235653spiffiest
spikiest14259533spikiest
spiniest102813223spiniest
spiriest102513453spiriest
spites84127333spi_tes_
squintest1845703squintest
stifles103013393stifles_
stillest8311073stillest
stoutest837613stoutest
strictest1147293strictest
subtest9513963s_ubtest
suites63727403sui_tes_
surfiest112414433surfiest
sveltest1135873sveltest
swankest15105933swankest
sweatiest1238413sweatiest
swellest1137663swellest
swift116818053swif___t
swiftly1633733swift_ly
swimmiest1634253swimmiest
swinges113413423swinges_
swingiest13207573swingiest
swipes114114333swi_pes_
swiples12339643swiples_
swirliest1236293swirliest
swishes133411373swishes_
swishiest1535513swishiest
swisses10417143swisses_
swives123915183swi_ves_
swivet123615473swi_ve_t
swivets13436963swivets_
tritest7315273tri_test
twiniest1147153twiniest
twistiest1235433twistiest
wattest102412153_wattest
wettest10239363_wettest
whitest133710113_whitest
widest104517003_wi_dest
wifes114522563_wif_es_
wildest113311273_wildest
wiliest103416593_wiliest
winiest103419693_winiest
wiriest103816853_wiriest
wisest95016443_wi_sest
wites85536963_wi_tes_
wittiest112711523_wittiest

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.1531167915.0
2DLD Change Limit1461621067.45619603.3
3Display Results1061060.0303533.3
 (SQL Overall)1786911067.63923391.9
 
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.