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 “exactest” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
exactest174545(None) 
exactas16336432exactas_
exacted1737302exacte_d
exacter1637402exacte_r
exacters1736772exacters
exactness1843622exactness
exacts15359612exact_s_
acutest94410603__acutest
aptest82917513__aptest
attest62618613__attest
blackest16269303blackest
chastest1349703chastest
coattest1038863coattest
daftest11248943_daftest
earnest7318733e_arnest
easiest72318773e_asiest
ecartes94212563ecartes_
elates65032363ela_tes_
enacted10310643enacte_d
enactment1348163enactment
enacts84012973enact_s_
enates64026423ena_tes_
epacts105010393epact_s_
etatist7415033eta_tist
exabytes2043613exabytes_
exact143516933exac___t
exacta15337393exact__a
exacting1838523exacting
exaction1738953exaction
exactly1953823exact_ly
exactor1636623exact_or
exactors1737013exactors
exalted1537393exalte_d
exalter1437563exalte_r
exalters1536653exalters
exalts13328313exalt_s_
exapted1736073exapte_d
except1797653ex_c_ept
excess1546053ex_c_ess
excites16310633excites_
executes1736533executes_
existent1548263existent
extent132714913ex__tent
fastest102413723_fastest
fattest102913063_fattest
featest102715113fea_test
flattest1138713flattest
iratest7312483ira_test
laciest93819033_laciest
latest63822703_la_test
neatest72516003nea_test
paciest112917803_paciest
peartest10311303peartest
phattest1336913phattest
raciest92820013_raciest
saltest71916513_saltest
scantest101710183scantest
sedatest9249393seda_test
slackest14289393slackest
smartest10310183smartest
spaciest122310893spaciest
stactes91914633stactes_
tartest72517533_tartest
tautest72612443_tautest
vastest102911513_vastest
wackest164710863_wackest
wattest102412153_wattest

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.436409841.7
2DLD Change Limit146162676.66021946.2
3Display Results67670.0302233.3
 (SQL Overall)178691677.12625075.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.