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

37 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
devoutest134364(None) 
devotes113713752devo_tes_
devouter1235512devoute_r
devoutness1443102devoutness
decentest1249083decentest
decongest1345633decongest
deforest1238793defo_rest
deftest112611713de__ftest
delouses9310013delouses_
demotes104717673demo_tes_
demotist11311843demo_tist
demurest1137453de_murest
denotes83817003deno_tes_
deputes104911783de_putes_
detest74122843de___test
devest104418703dev___est
deviates12312733deviates_
devoices14307413devoices_
devolves15286263devolves_
devote104513783devo_te__
devoted124111093devo_te_d
devotee113811823devo_te_e
devotees12286283devo_tees
devoured1335723devoure_d
devourer1235063devoure_r
devourers1344093devourers
devours1166643devou_rs_
devout10712993devou___t
devoutly1542663devout_ly
dourest8312943d__ourest
evolutes1156063_evolutes_
remotest103310723remo_test
reroutes8312223reroutes_
resolutest1053923resolutest
revotes104716393revo_tes_
stoutest837613_stoutest
veloutes1136153veloutes_

Search took 7 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.1561145455.1
2DLD Change Limit148641376.18624028.6
3Display Results37370.0162312.5
 (SQL Overall)178691376.35828104.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.