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

73 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
adeptest114545(None) 
adepter1036112adepte_r
adeptness1273952adeptness
adepts9117102adept_s_
alertest8310172alertest
aptest82917512a__ptest
deftest112611712_deftest
detest74122842_de_test
abruptest1342743abruptest
acerbest1245463acerbest
acutest94410603a_cutest
adapted1135843adapte_d
adapter1036173adapte_r
adapters1136103adapters
adapts9107813adapt_s_
addrest958633ad_drest
adept81219643adep___t
adeptly1344183adept_ly
adopted1136253adopte_d
adoptee1048413adopte_e
adoptees1145123adoptees
adopter1036763adopte_r
adopters1136693adopters
adopts998083adopt_s_
adroitest1044763adroitest
advertent1356593advertent
aeriest73924053a_eriest
amplest11312333a_mplest
anapaest1046023anapaest
anapest9311553anap_est
appetent1248083appetent
aretes64425353are_tes_
asepses946363asepses_
attest62618613a__ttest
crepiest12310383crepiest
daftest11248943_daftest
dampest12411043damp_est
deadest93014883_deadest
deafest112911513_deafest
dearest83618673_dearest
deepest10310443_deepest
deffest14308803_deffest
densest83112473_densest
dentist8316743_dentist
depress10239873_depress
depths12428573_depths_
deputes104911783_deputes_
detect94217403_de_tect
detent73624483_de_tent
detests83711743_de_tests
devest104418703_de_vest
dewiest11312343_dewiest
dopiest103315993_dopiest
featest102715113_featest
fleetest1136723fleetest
greatest939863greatest
heppest14228143_heppest
ideates8313733ideates_
jadeites1645823jadeites_
leftest10269463_leftest
modestest1245003modestest
neatest72516003_neatest
pertest9317043_pertest
pretest9517633pre_test
retest64028453_re_test
sedatest9249393sedatest
seepiest102412623seepiest
septet8921133_septe_t
septets998953_septets
sveltest1135873sveltest
sweetest1137173sweetest
weepiest13219473weepiest
wettest10239363_wettest

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.406440125.6
2DLD Change Limit146162737.18620339.8
3Display Results73730.0164562.5
 (SQL Overall)178691737.60823487.3
 
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.