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

109 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
obtested113545(None) 
obtected1344551obtected
attested936292attested
bested94922752_b_ested
contested12310692contested
detested10279622detested
objected2043492objected
obsessed1144272obsessed
obtest81213012obtest__
obtests9136232obtest_s
obverted1435102obverted
retested92212532retested
tested74421522__tested
untested92612412untested
abetted1058323ab_etted
absented1156613absented
arrested939153arrested
attester836503attester
basted95227233_b_asted
belted94020633_b_elted
bestead10389113_b_estead
bestud9439303_b_estud
betted94721163_b_etted
bilsted1038033_bilsted
blasted104213473_blasted
bleated104015973_bleated
blessed10319493_blessed
boasted104113743_boasted
boosted104111983_boosted
breasted1138823_breasted
bursted1039423_bursted
busted95123153_b_usted
chested133811673_chested
coattested1342973coattested
congested1338673congested
contented12313043contented
contester11311183contester
crested103416533_crested
detected12289733detected
detester9239683detester
devested13239133devested
digested11208163digested
divested13268213divested
egested938123_egested
forested12312463forested
guested9157713_guested
hostessed1344353hostessed
infested12249643infested
ingested10259003ingested
invested12229693invested
jested144416503__jested
molested11178243molested
nested74720063__nested
nonvested1346003nonvested
obese75212423ob_es_e_
obeyed1235823ob_e_yed
observed1444373observed
obsesses1036223obsesses
obtained1136533obtained
obtect10129633obtect__
obtesting1245883obtesting
obtruded1243363obtruded
obtunded1243523obtunded
obturated1245953obturated
obtuse8147483obtus_e_
obtuser9134453obtus_er
obviated1444563obviated
octette946423octette_
octettes1045533octettes
oersted839553o_ersted
oftest91212003oftest__
oriented937483oriented
ousted73720583o__usted
outacted1139383outacted
outasked1337123outasked
outdated1012513193outdated
outeaten8310423outeaten
outfasted13147173outfasted
outfeasted1444313outfeasted
outlasted10128353outlasted
outrated92219313outrated
outsped101110323out_sped
outvoted1237273outvoted
outwasted13137683outwasted
ovotestes1242533ovotestes
patented1188893patented
pretested12149113pretested
priested1138393priested
protested12159113protested
quested17168383_quested
reested82916233_reested
renested92212953renested
rested74430783__rested
retasted92412113retasted
revested122612243revested
stetted82610403_stetted
tasted74123973__tasted
teated74924023__teated
tented74221003__tented
testee64323303__testee
tester64227153__tester
testes65125823__testes
unrested91914513unrested
untasted92011573untasted
untented92613413untented
unvested122210223unvested
vested104217353__vested
wrested113410933_wrested
zested164214043__zested

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.440406115.9
2DLD Change Limit1461621097.04620744.0
3Display Results1091090.0303633.3
 (SQL Overall)1786911097.51623774.7
 
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.