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

135 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
rancored113722(None) 
rancoured1244691rancoured
anchored1438592_anchored
cancered132411552cancered
encored10412102_encored
ranched133113602ranc_hed
rancor8810372rancor__
rancors9811372rancor_s
ransomed1146932ransomed
razored1736332ra_zored
rescored114513102rescored
accord1178843_accor_d
accorded14155353_accorded
acorned10238273_a_corned
acred87126353_a_c_red
adored84714243_a_dored
alcoved1375613_alcoved
anchoret13412453_anchoret
ancone83916953_ancone_
ancones93116343_ancones
aneared8512743_aneared
angered93013473_angered
annoyed1185873_annoyed
antired82316193_antired
arbored103811603_arbored
armored102610473_armored
ascared10399523_ascared
bandore10611633bandore_
bandores11311603bandores
bannered11299323bannered
bantered113313633bantered
branched163210453branc_hed
buncoed12378443bunco_ed
canceled13279403canceled
cancroid1346523cancroid
cankered153010223cankered
cannoned11118143cannoned
canoed94618963can_o_ed
cantered113415983cantered
cantoned111411523cantoned
censored11197953censored
clangored1343653clangored
coanchored1843273coanchored
concord12510343concor_d
cored85044223___cored
cranched163210413cranc_hed
danced105315253danc__ed
dandered112110963dandered
dangered11248513dangered
enamored1147033enamored
encoded1139033_encoded
encore8314773_encore_
encores9315213_encores
factored1436213factored
fancied133310603fanc_ied
favored1455983fa_vored
francized2445583francized
gandered112211173gandered
hangared1337573hangared
hankered16289443hankered
harbored1438633harbored
honored11310123hon_ored
ignored9226443ign_ored
labored102810243la_bored
lanced93717723lanc__ed
lanceted1137073lanceted
majored1735853ma_jored
manicured1443733manicured
mannered11249653mannered
manured1039473man_ured
mentored1138003mentored
minored10310103min_ored
nacred95212493na_c_red
noncore9411953noncore_
pancaked1734893pancaked
pandered121812573pandered
pandore10411853pandore_
pandores11312453pandores
pastored1139963pastored
pranced123714043pranc__ed
prescored14409403prescored
raced87635313ra_c__ed
racemed1237013ra_cemed
racked134526083ra_c_ked
radioed939673radio_ed
raftered1237663raftered
rance75028513ranc__e_
rances84625443ranc__es
rancher123013633ranc_her
ranchero13277423ranchero
ranchers133311793ranchers
ranches123620113ranc_hes
ranchmen1545833ranchmen
rancid9513863ranc__id
rancorous1145283rancorous
rancour987133ranco_ur
rancours1076713rancours
ranged84824313ran__ged
ranked114620743ran__ked
rankled123910653ran_kled
ransomer1047883ransomer
ranted74324703ran__ted
rapiered1136053rapiered
raptured1155463raptured
rared65738323ra___red
rationed9410093rationed
ratooned977103ratooned
rawboned14114253rawboned
rebored105015883r_ebored
recoded113115033r_ecoded
record96117433r_ecor_d
recorded122511063r_ecorded
recorked15239853r_ecorked
rendered102512263rendered
rescore95616203rescore_
rescores105415693rescores
restored96417193restored
ripcord1264463ripcor_d
rumored1046643r_umored
sacred94917103sa_c_red
savored1158343sa_vored
scored94621133__scored
snored74819543_sn_ored
succored13135173succored
tabored102810563ta_bored
tailored936203tailored
tangoed9318833tango_ed
tranced104414173tranc__ed
unanchored1643173unanchored
uncoded11312743_uncoded
uncorked152210403_uncorked
uncured10513233_uncured
vapored1336923va_pored
wandered132110793wandered
wantoned12117223wantoned

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 Limit1461621357.28320068.9
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.74923059.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.