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

101 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
tabarded123474(None) 
abraded1138642_abraded
awarded1236222_awarded
barded105426422__barded
hazarded2243642hazarded
tabard9313332tabar__d
tabards10310382tabard_s
tabaret92717312tabar_et
tabered103311592taber_ed
tabored102810562tabor_ed
abased96514993_aba_sed
abashed1357663_abashed
abated95918453_aba_ted
abided105313313_ab_ided
aboded104912513_ab_oded
aborted10310423_aborted
abrade9313053_abrade_
abrader1038643_abrader
abrades10312073_abrades
alarmed1037733_alarmed
awardee1137553_awardee
awarder1135893_awarder
balded105417513__balded
banded105223173__banded
barbed115121313__barbed
barde85330773__barde_
bardes95026933__bardes
bared85144483__bar_ed
barfed125416383__barfed
barged105822643__barged
barked135027313__barked
barned95623583__barned
barred95725793__barred
bearded114212133_bearded
birded104414303__birded
boarded113910503_boarded
bombarded17123633bombarded
caballed1337163caballed
cabaret112519043cabar_et
carded105424903__carded
debarked16175823debarked
debarred12165633debarred
debearded1443373debearded
embarked17205213embarked
embarred13174793embarred
farded114518953__farded
guarded1036153_guarded
hazarder2143603hazarder
hoarded12368343_hoarded
imbarked17254063imbarked
labored102810243labor_ed
larded84319093__larded
mansarded1343993mansarded
marauded1244333marauded
paraded114014263para_ded
placarded1543253placarded
reboarded1365613reboarded
regarded11279803regarded
retarded102410753retarded
rewarded13229523rewarded
sabered103213023saber_ed
sabred95916533sab_r_ed
safaried1236253safaried
salaried9311023salaried
scabbarded1851533scabbarded
starboarded1552183starboarded
stewarded1443533stewarded
swarded1238153_swarded
tabanid1047323taba_nid
tabarets10287233tabarets
tabbed114215363tab__bed
tabbied12297793tab_bied
tabled94020043tab__led
tableted1137533tableted
tabooed10267383tab_ooed
taborer9269293tabor_er
taboret92916113tabor_et
taboured1156273taboured
tabued94310403tab__ued
tamarind1147013tamarind
tapered102612933taper_ed
tared69340053t__ar_ed
tarred74720283t__arred
tarried83914133ta_rried
tarted74923373t__arted
teared75722153t_ear_ed
thwarted1533363thwarted
tiaraed837043t_iaraed
traded85717683t_ra_ded
treaded95014283trea_ded
unabraded1344893unabraded
unawarded1444923unawarded
unbanded123010563unbanded
unbarbed13217753unbarbed
unbarred11238703unbarred
unbearded13146343unbearded
unboarded13185683unboarded
uncarded12310133uncarded
vizarded2242753vizarded
warded115021043__warded
yarded114714023__yarded

Search took 9 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.1561145455.1
2DLD Change Limit1461621018.70316794.4
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.90520066.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.