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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
sabred9591653(None) 
sabbed114518081sabbed
sabed86526811sab_ed
sabered103213021sabered
sabre74821501sabre_
sabres85520861sabres
sacred94917101sacred
abed79734132_ab_ed
abled86926832_abled
acred87126352_acred
aired66032922_aired
babied114913512babied
barbed115121312barbed
bared85144482ba_red
barred95725792barred
bred75130972__bred
cabbed135416262cabbed
cabled114819872cabled
cared86050092ca_red
dabbed124416142dabbed
dared75935012da_red
eared65139502ea_red
fabled124216382fabled
faired105915772faired
fared95842342fa_red
gabbed125216892gabbed
gabled105518452gabled
garbed104815662garbed
garred85217412garred
haired105117172haired
hared95742182ha_red
hatred104814332hatred
inbred93010402inbred
jabbed184213482jabbed
jarred144613252jarred
labored102810252labored
labret8320222labret
laired75216812laired
marred95421042marred
nabbed115113612nabbed
nacred95212492nacred
oared65030652oa_red
paired95017522paired
pared86946762pa_red
parred95024072parred
rared65738322ra_red
rebred95816352rebred
sabe66140572sab_e_
saber75330242sab_er
sabers85224732sabers
sabes76437462sab_es
sable74732162sable_
sables85026692sables
sabra75317852sabr_a
sabras85116362sabras
sacked135525212sacked
sagged94120012sagged
sailed74327762sailed
sained75424242sained
salted74121202salted
salved103916422salved
sambaed1238302sambaed
sanded84920612sanded
saned65636272sa_ned
sapped114422012sapped
sard55344242sa_r_d
saree55044662sa_ree
sarod65325872sa_rod
sashed105622942sashed
sassed76116172sassed
sated66238532sa_ted
sauced93913302sauced
saurel6511992saurel
sauted74119602sauted
saved95127112sa_ved
savored1158342savored
sawed95628402sa_wed
sayed96127142sa_yed
scabbed14408222scabbed
scared95227292scared
scarred104512632scarred
scored94621132scored
seabed95017692seab_ed
seared75232842seared
sered65737292s_ered
shared105829062shared
shored105723652shored
shred98125612s_hred
sired66134282s_ired
slabbed12409502slabbed
snared74824552snared
snored74819542snored
soared74324292soared
sobbed113516262sobbed
sobered102912432sobered
sorbed94916522sorbed
sored66141782s_ored
soured74921862soured
spared95427492spared
sparred104512862sparred
spired94921862spired
spored94821792spored
stabbed123510372stabbed
stabled103514952stabled
stared75429872stared
starred85013452starred
stored75524212stored
subbed114116672subbed
swabbed15367402swabbed
tabbed114215362tabbed
tabered103311592tabered
tabled94020042tabled
tabored102810562tabored
tabued94310402tabued
tared69340052ta_red
tarred74720282tarred
unbred92613302unbred
waired106015832waired
wared96339872wa_red
warred104019842warred

Search took 4 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 Filter178691825510.346516448.0
2DLD Change Limit825511202.68630733.8
3Display Results1201200.0304000.0
 (SQL Overall)1786911203.06258357.6
 
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.